Ales,

At last was able to get rid of the error....
After a good checking found that there was indeed a buffer overflow and some infinite loops in my procedure.

Thanks for the help.

One more problem that I am getting is ORA-01722
The situation is like this.

I have got Comp_list as 123,456,789,12
and Comp_list is VARCHAR2(1000).

Now I have a query like

SELECT DISTINCT CATEGORYNAME FROM BCOMP_MAP WHERE BCNAME_ID IN (Comp_List);

In Bcomp_map table we have Categoryname as VARCHAR2(60) and BCNAME_ID as NUMBER(10)

So in the select query we have a type mismatch.

I thought of overcoming this using TO_NUMBER but didnt work..

Do u have any idea on how to overcome such a situation??


Thanks in advance