-- To run a package/procedure that returns a cursor in SQL*Plus VARIABLE rtn REFCURSOR exec schema.PAK_get.SP_GET_data('xxx','404',:rtn);