Reg: Need help to call a Stored Procedure with Out Parameter using DBAdapter in BPEL

HI

I have created a procedure with Out Parameter, using DBAdapater i have invoked it. I have assigned the out parameter also. But while running i am getting this error.

My Procedure is shown below. It executes successfully when its run in database.

create or replace

PROCEDURE SP_QUERY(s_string in varchar2, retCodeString out varchar2)

AS

l_sql_stmt varchar2(1000);

BEGIN

l_sql_stmt := s_string;

EXECute immediate l_sql_stmt;

commit;

if SQLCODE = 0 then 

retCodeString := 'OK';

end if;

END;

java.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: 

Client received SOAP Fault from server : Exception occured when binding was invoked.