Procedure return empty cursor

valigula

Member
Hi All,
I have been having this problem for few weeks now, and i would like to spend some time to try to fix it.
I have a procedure that is called from one application. The procedure returns a cursor with the data required by the app, this is working fine now. The problem is when i try to called the procedure directly from the pl/sql developer, in that case the proc returns an empty cursor. If i do my own script adding a dbms_out data is returned.

Using PL/Sql 9. Oracle 9i/11g.

It uses to work before.

Thanks
 
thanks for the reply.
One of the return parameters is a variable and it works fine. Yes cursor is aways empty :(. I have upgrade to the PL/SQL Developer latests version and having the same problem.
 
Back
Top