APEX

Hi There,

Facing a strange issue.

I have a regular cursor, and in that cursor loop I have a select statement into some variables based on cursor parameters.

I was getting the "ORA-01461: can bind a LONG value only for insert into a LONG column" error so I started individually checking each of the columns. Now it works fine for some column, but the moment I add this number field. It starts throwing this error. Now, the database source where the select is fired is of type number, the variable into which I select it is number .

Infact, I dont have any LONG column defined anywhere.

The strange thing is that the block executes perfectly fine in SQl developer. So looks like a Apex specific issue.

I am on 4.1/11g

Any ideas?

Thanks,
Sun