How to call a stored procedure using a ref cursor in Oracle with squirrel
The only syntax I get working in Squirrel SQL is PL/SQL block:
declarev_param1 varchar2:='param';v_param2 varchar2:='param';TYPE ref_cursor IS REF CURSOR;v_cur_results ref_cursor;beginMyProc (v_param1 , v_param2 , v_cur_results)end;/
If the tool does not support this facility the next best thing would be to create a proc that will output your cursor for you.
Luckly it has already been written for you. see rc_to_dbms_sql( in http://www.oracle-developer.net/display.php?id=505