OraFAQ Forum: Forms » "sys_refcursor" when expecting one of the following (

Home » Developer & Programmer » Forms » "sys_refcursor" when expecting one of the following (

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"sys_refcursor" when expecting one of the following ( [message #609084]

Sat, 01 March 2014 03:59

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;

Report message to a moderator

Re: "sys_refcursor" when expecting one of the following ( [message #609130 is a reply to message #609084]

Mon, 03 March 2014 02:41

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

Since when do you put the parameter data type in the call to a procedure?

Report message to a moderator

Previous Topic:	100501- non-ORACLE Exception
Next Topic:	trigger firing sequence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 09 15:06:11 CST 2026