Sqlj

Hi,

I am calling a Java code in SQL. Below is the detail.

I am creating a procedure 'A' which is using cursors (2 cursors) and is calling 'B'.

In procedure 'B', Java part is being called. Data is getting loaded . But i am getting the error as shown below.

"The cursor 'c1' can not be used as it could not be found. It is possible that either it was not declared or it is not available in the current context. "

and

"The cursor 'c2' can not be used as it could not be found. It is possible that either it was not declared or it is not available in the current context. "

Can anyone suggest me the solution ASAP.

Thanks in advance.