Stored Procs in Oracle Adapter

, ,
1

Can someone tell me how to run stored procs in Oracle adapter and get a output from it.I am trying to open a Ref Cursor and passing Input values to the stored Proc.My stored Proc is in Package also.It gives me a error saying ORA-01023: Cursor context not found (Invalid cursor number).I am opening the cursor too.If someone knows Please let me know.

Thanks
Puneet

2

Puneet

The following procedure works with orcale Adapter

reate or replace package packemp as
Status varchar2(100);
cursor empcursor is select Status from Dual;
Type type_Cursor is ref cursor return empcursor%rowtype;
procedure empinsert
(out_cursor in out type_cursor,
empno number,
name varchar2);
end packemp;
/

create or replace package body packemp as
procedure empinsert
(out_cursor in out type_cursor,
empno number,
name varchar2) is

Begin
BEGIN
insert into emp1 values(empno,name);
Status:=‘Done’;

	Exception
	When others then
	Status:=SQLERRM;
END;

	   	
Open out_cursor for Select Status from dual;

END EMPINSERT;
end packemp;