In Oracle SQL developer how to see output if we run procedure from query browser

Question

I am a little bit surprised when I compile and run procedure from the

green button as shown in pic1, I get the output from the output variable.

Here is my simple code:

CREATE OR REPLACE PROCEDURE RUNPROCEDURE
    (P_para1  in EMP.ID%type,P_PARA out SYS_REFCURSOR) 
AS 
BEGIN
    OPEN P_PARA FOR
       SELECT * 
       FROM emp 
       WHERE ID = P_para1;
END RUNPROCEDURE;

But when the same I run from the query browser, I did not see any output :=

set serveroutput on;
declare P_PARA1 number;
    P_PARA SYS_REFCURSOR;
begin
    RUNPROCEDURE(
        P_PARA1 => 2,
        P_PARA => P_PARA
    ) ;
end;
/

It just displays

PL/SQL procedure successfully complete

and I don't see any output.

Any help appreciated.

Have a look at this, perhaps of some help.

Jacob
– Jacob

2017-06-11 13:12:07 +00:00
Commented Jun 11, 2017 at 13:12 — Jacob
– Jacob, Commented Jun 11, 2017 at 13:12

Bob Jarvis - Слава Україні · Accepted Answer · 2017-06-10 11:34:36Z

5

The only output from this procedure is an output parameter cursor. SQL Developer provides a method of iterating this cursor semi-automatically, while SQL*Plus doesn't - but your procedure doesn't "return" those rows, it returns the cursor. Somewhere there has to be code to iterate through the cursor, fetch the rows, and display the content of those rows.

answered Jun 10, 2017 at 11:34

Bob Jarvis - Слава Україні

50.2k10 gold badges81 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

In Oracle SQL developer how to see output if we run procedure from query browser

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related