SQL & PL/SQL

Hi Folks,

I am using function in my sql query.i want to write this query in a cursor loop.

the thing is function is not updatable and it errors out for few records. now when i use the same function in cursor and loop it,it will stop the loop when it errors out.

can you guys please help me out if there is any way to continue the loop even there is an error in plsql .

My Function is as below:


Decalre

Cursor

select ***********************;

begin

loop
fetch********************

x:=function(**);

end loop;




Guys please help me on this. your help is high ly appreciated.

Thanks!!

Karthik T