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: Eric Fortin <emfortin_at_pcisys.net>
Date: Mon, 31 Dec 2001 07:20:30 -0700
Message-ID: <1$--$$-$-__$-----$@news.noc.cabal.int>


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 - 08:20:30 CST

Original text of this message

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