Hi all,

I want to call oracle procedure in report design and get return from the procedure like call test('111').

But it always pop up error as following:

java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TEST'

Procedure as following:

create or replace procedure test(name in varchar2, cusor_1 out SYS_REFCURSOR) is

begin
open cusor_1 for
select t.order_no from tkt_info t where t.tkt_no = name;
end;


Thanks !

Frank