Is there way to display the output of a Ref cursor (Oracle Package), in the results pane of the SQL editor?IF I right click on the Package body & then click "Execute", it generates code & executes, but there is no result output.
For some reason the SQLNV stubs in comment code which says "Unknown cursor return type,If required, edit code to display cursor output"And the Output window (DBMS_OUTPUT) says execution was succesful, but the output is Not displayed in this window either.
I do Not want to do FETCH/LOOP cursor routine & display this Ref cursor output which has so many columns.I want a easier & quicker way to displays the results in the grid.SQL Nav Ver: 22.214.171.1241
Code sample:DECLARETYPE CURSOR_TYPE_1 IS REF CURSOR;MyRefcursor CURSOR_TYPE_1;BEGIN
-- Now call the stored program MyApp_ora_package.MyApp_Rpt_Proc(MyRefcursor);
-- Output the results-- Unknown cursor return type-- If required, edit code to display cursor output
EXCEPTIONWHEN OTHERS THEN dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));RAISE;END;
Yes, Your screenshots are pointing to the problem in the right direction.If you refer to your screenshot, the Refcursor of 'get_products_ref_cursor', The 'Results' tab, should have displayed the output of 'products_ref_cursor' , which is a result of "Select product_id, name, price from products', in the grid pane below.But , it just says "return value (cursor)"Where is the output of the cursor in the grid?What use is it anyways just to show a value called "(cursor)" ?
As I mentioned I have SQL Nav 126.96.36.1991.I dont see this browse button functionalityCan this be done anyway, using this version?Attached screeshot of the SQLNav version I use.
Thanks for your replies.Finally, got it to work the way I wanted.Initially, could not replicate your steps from step#3 onwards.Both of us have different screen/settings , despite the same version.The important point here is to UNCHECK the settings "Direct values of OUT parameters to DBMS_OUTPUT". This will give the ellipses button "...the right extreme browse button" as you mentioned, & thereby, can view the Ref Cursor output.Hope, the attached screenshots better explains, what I did.Issue resolved.Thanks a lot!