Home » Developer & Programmer » Forms » "sys_refcursor" when expecting one of the following (
"sys_refcursor" when expecting one of the following ( [message #609084] Sat, 01 March 2014 03:59 Go to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,

How can i call the procedure using sys_refcursor

PROCEDURE test_ref (emp_cur IN sys_refcursor) 
IS
.....
.....


I want to call this procedure in the button.But Encountered the symbol "sys_refcursor" when expecting one of the following
(
DECLARE
     emp_cur VARCHAR2(8);
     v_Cursor SYS_REFCURSOR;
BEGIN
     emp_cur := :RHCLANDEDCOSTDET.file_number;
     message('Now calling procedure for file '||emp_cur);
     test_ref (emp_cur IN sys_refcursor);
END;
Re: "sys_refcursor" when expecting one of the following ( [message #609130 is a reply to message #609084] Mon, 03 March 2014 02:41 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Since when do you put the parameter data type in the call to a procedure?
Previous Topic: 100501- non-ORACLE Exception
Next Topic: trigger firing sequence
Goto Forum:
  


Current Time: Fri Mar 29 02:40:07 CDT 2024