Re: Please help! Oracle Stored Procedure from ASP giving error...

Have you #included adovbs.inc to define your ad* constants?

Jeff

"Kent P. Iler" <kent_at_iler.NOSPAM.com> wrote in message news:vM%X7.220$Gj.15543_at_typhoon.mw.mediaone.net...
> Now any suggestions on why I'm getting this error from ASP?
>
> --Kent
>
> "Eric Fortin" <emfortin_at_pcisys.net> wrote in message
> news:u30sriis61st12_at_corp.supernews.com...
> > SQL Plus:
> >
> > exec [proc_name](parameter1, parameter2, etc.);
> >
> > "Kent P. Iler" <kent_at_iler.NOSPAM.com> wrote in message
> > news:QtTX7.217$Gj.15032_at_typhoon.mw.mediaone.net...
> > > Hi,
> > >
> > > I'm trying to execute an Oracle stored procedure from ASP. We're
using
> > > Version 8i.
> > >
> > > The error I'm getting is:
> > > Microsoft OLE DB Provider for Oracle (0x80040E14)
> > > ORA-06550: line 1, column 7: PLS-00306: wrong number or types of
> arguments
> > > in call to 'GET_USER_SECURITY_PROC' ORA-06550: line 1, column 7:
PL/SQL:
> > > Statement ignored
> > > /danaPPM/NCMRForm.asp, line 335
> > >
> > > when I try to execute the procedure. Can you tell me how to test it
> from
> > > my machine from the SQLPlus prompt? I want to verify that it works.
> > >
> > > The proc header is:
> > >
> > > ---------------------------------------------------------------
> > >
> > > CREATE OR REPLACE PROCEDURE get_user_security_proc(i_user_id in
> varchar2,
> > > i_created_by in varchar2,
> > > o_edit_ncmr out boolean,
> > > o_edit_scar out boolean) AS
> > > ----------------------------------------------------------------
> > >
> > > Here's the code I'm using (it's been used before and has worked in the
> > > past...just not with this SP):
> > >
> > > ---------------------------------------------------------------
> > >
> > >
> > > Set cmdStoredProc = Server.CreateObject ("ADODB.Command")
> > > Set cmdStoredProc.ActiveConnection = Conn
> > > cmdStoredProc.CommandText = "GET_USER_SECURITY_PROC"
> > > cmdStoredProc.CommandType = adCmdStoredProc
> > >
> > > 'Current UserID
> > > Set param1 = cmdStoredProc.CreateParameter ("i_user_id",
adLongVarChar,
> > > adParamInput, 30)
> > > param1.Value = "SYERRAM"
> > > cmdStoredProc.Parameters.Append param1
> > >
> > > 'Author UserID
> > > Set param1 = cmdStoredProc.CreateParameter ("i_created_by",
> adLongVarChar,
> > > adParamInput, 30)
> > > param1.Value = "SYERRAM"
> > > cmdStoredProc.Parameters.Append param1
> > >
> > > 'Edit NCMR
> > > Set param1 = cmdStoredProc.CreateParameter ("o_edit_ncmr", adBoolean,
> > > adParamOutput)
> > > cmdStoredProc.Parameters.Append param1
> > >
> > > 'Edit SCAR
> > > Set param1 = cmdStoredProc.CreateParameter ("o_edit_scar", adBoolean,
> > > adParamOutput)
> > > cmdStoredProc.Parameters.Append param1
> > >
> > > Set rsTemp = cmdStoredProc.Execute
> > >
> > > ---------------------------------------------------------------
> > >
> > >
> > >
> > > Any help would be appreciated!
> > >
> > > Thank you!
> > >
> > > --Kent Iler
> > > (To response via e-mail, remove the .NOSPAM from the e-mail address)
> > >
> > >
> > >
> >
> >
>
>
Received on Mon Dec 31 2001 - 11:09:01 CST