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

From: Kent P. Iler <kent_at_iler.NOSPAM.com>
Date: Mon, 31 Dec 2001 06:21:36 GMT
Message-ID: <QtTX7.217$Gj.15032@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 - 00:21:36 CST