Run stored procedure with cursor output in Sql Oracle?

Question

I have an sp from a package that look like this

PROCEDURE SEARCH_SOMETHING (
InParam          IN     VARCHAR2,
InParam2            IN     NUMBER,
OutCursor              OUT empcur)

How can I run this and see the data that the cursor retrieve?

kapil · Accepted Answer · 2018-10-09 14:59:12Z

1

You can simply call the cursor in the begin end block. Or use the Execute statement.

DECLARE
    L_INPARAM VARCHAR2;
    L_INPARAM2 NUMBER;
    L_OUTPARAM empcur;
BEGIN
    L_INPARAM:= value;
    L_INPARAM2:= VALUE_NUMBER;
   SEARCH_SOMETHING (
          L_INPARAM,
          L_INPARAM2
          L_OUTPARAM);

for i in L_OUTPARAM 
 loop
   use values of i;
 END LOOP:
END;

answered Oct 9, 2018 at 14:59

kapil

4192 silver badges7 bronze badges

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

Collectives™ on Stack Overflow

Run stored procedure with cursor output in Sql Oracle?

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