CREATE OR REPLACE PROCEDURE spGetTreeViewItems1 (p_spGetTreeViewItems OUT SYS_REFCURSOR, firstParam string) is Begin open p_spGetTreeViewItems for Select * from TREEVIEW; End spGetTreeViewItems1;
set serveroutput on; variable rc refcursor, fn fstname exec spGetTreeViewItems1( :rc ); print rc, fn; Try 2: execute spGetTreeViewItems1;
exec spGetTreeViewItems1( :rc, :fn );
set serveroutput on; variable rc refcursor, fn string; exec spGetTreeViewItems1( :rc, :fn ); print rc, fn;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)