oracle 9i stored procedure called by ASP

From: dodo <dominique_hung_at_hotmail.com>
Date: Mon, 2 Aug 2004 19:29:54 +0200
Message-ID: <celtmh$l5b$1@sunnews.cern.ch>

Hi,

I'm trying to call a stored procedure(package) from asp/vb using following code
but I got the error message. Could someone tell me the correct syntax??

---

code:
Set objConn = Server.CreateObject("ADODB.Connection") Set objCmd = Server.CreateObject("ADODB.Command") Set objRs = Server.CreateObject("ADODB.RecordSet")

objConn.ConnectionString = "DRIVER={Microsoft ODBC for Oracle};SERVER=HOME; UID=test;PWD=test"
objConn.Open()
objCmd.ActiveConnection = objConn

objCmd.CommandText = "{call PkgPartition.add(?)}" objCmd.CommandType = adCmdText

objCmd.Parameters(0).Value = Request.Form("partName") ojbCmd.execute()

---

error message :
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC driver for Oracle][Oracle]ORA-20004: /part.asp, line 24

---

Note the signature of package :
Create or Replace package PkgPartition IS Function createPartition(paramPartName IN varchar2) Return NUMBER; Procedure add(paramPartName in Varchar2);

Thanks in advance for your help Received on Mon Aug 02 2004 - 12:29:54 CDT