Re: 0040

Try ExecSQL instead.

I don't know what you are trying to do but my tool Oraxcel may be of use to you I guess. I've implemented all of this before so if you need an end product you may use Oraxcel LITE which is completely free.

Oraxcel can be downloaded from http://members.aol.com/gjlinker

Oraxcel is an addin for Excel and allows you to use Excel as a frontend to Oracle databases.

Regards, Gerrit-Jan Linker

jcho wrote in message ...
>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 Sat Aug 14 1999 - 17:13:51 CDT