How to execute a procedure from SQL Commander which has refcursor as a out parameter in db-visulizer

223 views Asked by At

I have checked many SO Answers pertaining to this topic, but couldn't get the correct answer which is DB-VISUALIZER centric.This is the start and end of my procedure in DB-VIZ

CREATE OR REPLACE PROCEDURE "pivot_view"( res out sys_refcursor )
dbms_output.put_line(query);
    open res for query;
end pivot_view;

To execute it from SQL Commander , I wrote :

@ECHO ${rc ||32767||refcursor}$ @CALL pivot_view(rc); PRINT rc which doesn't seem to work.

How do I execute my compiled procedure

0

There are 0 answers