Ref cursor does not throw exception
Hi There
I've got a procedure that returns a ref cursor. I've found an error in the select statement that populates the cursor, but when I execute the procedure from pl/SQL it does not give me any error. If I execute the same procedure from .Net it gives me the appropriate error. Why is Oracle not giving me an error from PL/SQL?? It makes it extremely difficult to try and trace errors!!
The error is in the in-line select statement in the cursor, is needs to have the rownum = 1 specified not to fail.
Example Code:
PROCEDURE SP_SPCREPORT2(p_Workstation IN varchar2,
I've got a procedure that returns a ref cursor. I've found an error in the select statement that populates the cursor, but when I execute the procedure from pl/SQL it does not give me any error. If I execute the same procedure from .Net it gives me the appropriate error. Why is Oracle not giving me an error from PL/SQL?? It makes it extremely difficult to try and trace errors!!
The error is in the in-line select statement in the cursor, is needs to have the rownum = 1 specified not to fail.
Example Code:
PROCEDURE SP_SPCREPORT2(p_Workstation IN varchar2,
0