I have one procedure, which will form a query needed for some reports.. its giving me some error which i am unable to find out, only for one particular type of parameter values..
actually i have a table sam, in which i am storing the query which is generated by the proc, but only for one particular condition the record is not getting inserted.. actually i tried to debug and found out that an insert statement is failing.. but unable to find out the reason why.. googled out the error, but haven't found a reasonable solution..
attaching the procedure to replicate the error, appreciate your help in resolving this..
attache is the proc,
before this one has to create this table
create table sam (col1 clob);
and after this procedure to be compiled, which will get compiled without any errors and has to execute this block
you will see the error when you do select * from sam
ORA-01461: can bind a LONG value only for insert into a LONG column