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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help! Oracle Stored Procedure from ASP giving error...

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

From: Kent P. Iler <kent_at_iler.NOSPAM.com>
Date: Mon, 31 Dec 2001 15:47:39 GMT
Message-ID: <vM%X7.220$Gj.15543@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 - 09:47:39 CST

Original text of this message

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