Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 0040
I am using 0040 in asp script to kick off PL/SQL stored procedure, using
OraDatabase.Parameters.Add "ACT", x,1,1 'input OraDatabase.Parameters.Add "PASS",y,1,1 'inputOraDatabase.Parameters.Add "USER",update_user,1,1 'input OraDatabase.Parameters.Add "STATUS",pswStatus,2 ,2 'output
Set sqlstmt=OraDatabase.CreateSql("Begin pass_chk(:ACT,:PASS,:USER,:STATUS);
end;",0)
rc=OraDatabase.Parameters("STATUS").value
However, it looks that it never kicks off the stored procedure.