ORDS, SODA & JSON in the Database

Hi,

I have some problem to run stored procedure with parameter (works without parameter)
this works with APEX LISTENER version 0.10.110.10.57. (tested on tomcat and on Oracle GlassFish Server 3.0.1)

Regards,

call is done via url like :
DRAP_APX_PUB.DL_DRATB_SCH_MIG_TEM_DTA?p_col_nam=RCH_MIG_DDL_DCT&p_MIG_SCH_SVC_REQ_IDN=1182&p_ext=.sql

receive : HTTP Status 500

APEX Listener version : 1.10.179.10.43

ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
init: # headers=45
declare nm owa.vc_arr := ?;
vl owa.vc_arr := ?;
begin
owa.init_cgi_env( ?, nm, vl );
htp.init; htp.HTBUF_LEN := 63;
? := sys_context('USERENV','SID');
end;
SID:492
CALL:
begin
DRAP_APX_PUB.DL_DRATB_SCH_MIG_TEM_DTA(p_ext=>?,
p_col_nam=>?);
commit;
end;
BINDS
p_ext:.sql
p_col_nam:RCH_MIG_DDL_DCT
p_ext:.sql
p_col_nam:RCH_MIG_DDL_DCT
EXEC FAILED:ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'DL_DRATB_SCH_MIG_TEM_DTA'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'DL_DRATB_SCH_MIG_TEM_DTA'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored



[#|2010-07-05T14:21:54.613+0200|SEVERE|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=23;_ThreadName=Thread-1;|_init_: # headers=45
declare nm owa.vc_arr := ?;
vl owa.vc_arr := ?;
begin
owa.init_cgi_env( ?, nm, vl );
htp.init; htp.HTBUF_LEN := 63;
? := sys_context('USERENV','SID');
end;
SID:485
CALL:
begin
DRAP_APX_PUB.DL_DRATB_SCH_MIG_TEM_DTA(p_ext=>?,
p_col_nam=>?);
commit;
end;
BINDS

p_ext:.sql
p_col_nam:CRO_MIG_DDL_DCT
p_ext:.sql
p_col_nam:CRO_MIG_DDL_DCT
EXEC FAILED:ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'DL_DRATB_SCH_MIG_TEM_DTA'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
|#]

[#|2010-07-05T14:21:54.617+0200|SEVERE|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=23;_ThreadName=Thread-1;|ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'DL_DRATB_SCH_MIG_TEM_DTA'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
|#]