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
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