🚀 go-pugleaf

Dear all,

Please advise how should I use the ADOStoredProc to execute a stored
procedure on Oracle8i?

The store procedure is something like:

CREATE OR REPLACE procedure tbl_input( v_out out varchar2, v_id in varchar2,
v_upd in varchar2, v_1 in varchar2:=null
  ,v_2 in varchar2:=null,v_3 in varchar2:=null,v_4 in varchar2:=null,v_5 in
varchar2:=null
  ,v_6 in varchar2:=null,v_7 in varchar2:=null,v_8 in varchar2:=null,v_9 in
varchar2:=null,v_10 in varchar2:=null)
is
  v_date date;
  err_msg varchar2(100);
begin
 v_date := to_date(v_upd,'yyyymmddhh24miss');
  update tbl set timestamp=sysdate,upd =
v_date,n1=v_1,n2=v_2,n3=v_3,n4=v_4,n5=v_5
     ,n6=v_6,n7=v_7,n8=v_8,n9=v_9,n10=v_10 where id=v_id;
  if sql%notfound then
      insert into tbl (timestamp,id,upd,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10)
        values
(sysdate,v_id,v_date,v_1,v_2,v_3,v_4,v_5,v_6,v_7,v_8,v_9,v_10);
      v_out := '00#Insert '||v_id;
  else v_out := '00#Update '||v_id;
  end if;
  commit;
EXCEPTION
 when others then
   rollback;
    err_msg := substr(SQLERRM,1,100);
    v_out := '01#'||v_id||'-'||err_msg;
end ;

I tried a variety of settings in the parameters but continually received the
EOleException with message:
Parameter object is improperly defined. Inconsistent or incomplete
information was provided

Furthermore, how can I inspect the parameter values in debug mode?

Thanks and regards,
Patrick