Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 0040

0040

From: jcho <cho5_at_home.com>
Date: Fri, 30 Jul 1999 13:38:54 GMT
Message-ID: <OVho3.81498$eF3.25600@news.rdc1.nj.home.com>


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        'input
 OraDatabase.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.

  1. Is there any way I can check at the Oracle such as using "TRACE". I did "ALTER SESSION TRACE TRUE" to see what is coming? Nothing is showing in the ORACLE from any OO4O calls.
  2. Anybody would be appreciated if you lead me into a happy solution.
Received on Fri Jul 30 1999 - 08:38:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US