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