Problem with REFCURSOR

[sainiamit25]

Hi All,

I have an oracle procedure which takes in some parmeters and passes the output as SYS_REFCURSOR variable to some other schema (when called). Problem is when the other schema tries to use this cursor, they are getting error- “Invalid Operation, DataRead is Closed”. I am able to read in the contents of this cursor using loop and fetch in my own procedure. Can someone please throw some light as to where the problem might be? This proecedure was working on all other environments before it was brought to this new environment. Does it have to do something with grants etc?

Thanks in advance for your help.

Thanks & Regards,
Amit

[debasisdas]

Can you kindly post the code that yu are using for reference of our expets please .

[Pilgrim333]

Hi Amit,

In addition to posting the code, could you answer a few questions?
- What is the difference between the new environment and the other environments?
- Does the code work when you call the procedure in another procedure in it's own schema?
- Are you trying to access the cursor through an Oracle procedure or through a java or dotnet application?

Pilgrim.