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 -> REPOST: Re: Please help! Oracle Stored Procedure from ASP giving error...

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

From: Kent P. Iler <kent_at_iler.NOSPAM.com>
Date: Mon, 31 Dec 2001 20:44:08 GMT
Message-ID: <5$--$$-$-_%--_-$%$@news.noc.cabal.int>


Finally! It wasn't my code....well, not my ASP code. I was searching through MSDN and found this article:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q306530

You can't have Boolean values as output variables! We changed them to Int, and it's working great!

Thanks for any and all who offered help!

--Kent

"Jeff Dillon" <jeffdi_at_fidalgo.net.remove> wrote in message news:#c$OZ3hkBHA.3588_at_tkmsftngp04...
> 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)
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

autocancel Received on Mon Dec 31 2001 - 14:44:08 CST

Original text of this message

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