Re: Help with Oracle, Store Procedures, Refcursors, ASP, ADO

Thanks Tak.

Anyone know where I can find the installer for the Procedural Option? I did a install of the Oracla 9i client, but I don't think that comes with it.

tsato_at_web.de (Tak Sato) wrote in message news:<330fe73e.0303270057.2702dc48_at_posting.google.com>...
> hi David
>
> here. the error-def:
> -->ORA-00900 invalid SQL statement
>
> Cause: The statement is not recognized as a valid SQL statement. This
> error can occur if the Procedural Option is not installed and a SQL
> statement is issued that requires this option (for example, a CREATE
> PROCEDURE statement). You can determine if the Procedural Option is
> installed by starting SQL*Plus. If the PL/SQL banner is not displayed,
> then the option is not installed.
>
> Action: Correct the syntax or install the Procedural Option.
> <--
>
> check your SQL-statement first.
>
> Tak
>
>
>
>
>
> dpio222_at_earthlink.net (David Pio) wrote in message news:<32b291b3.0303261750.7a02b6b3_at_posting.google.com>...
> > I am using ASP and ADO to connect to an Oracle DB. There is a stored
> > procedure I want to call that returns a refcursor as one of the
> > parameters. Everytime I try to execute I get a "
> > [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement " message.
> >
> > any solution? the database is setup correctly as others have used that
> > same procedure w/ Perl and JDBC.
> >
> > Here is a code snippet, the stored procedure 'command' in package
> > 'package' has 2 parameters, the 1st is the refcursor, the 2nd is a
> > text character
> >
> >
> > // Create the command object and set the query to be executed
> > Set objCmd = Server.CreateObject("ADODB.Command")
> > Set objCmd.ActiveConnection = objConn
> > objCmd.CommandType = adCmdStoredProc
> > objCmd.Parameters.Append(objCmd.CreateParameter("param2", adVarChar,
> > adParamOutput, 4))
> > objCmd.CommandText = "package.command" //(:refcur,:stat)
> >
> > Set objRS = Server.CreateObject("ADODB.RecordSet")
> > objRS.CursorType = adOpenStatic
> > objRS.LockType = adLockReadOnly
> > Set objRS = objCmd.Execute()
> >
> >
> > Thanks!
Received on Mon Mar 31 2003 - 21:13:06 CEST