OraFAQ Forum: SQL & PL/SQL » Help to call Oracle Stored Funciton from ASP3.0

Home » SQL & PL/SQL » SQL & PL/SQL » Help to call Oracle Stored Funciton from ASP3.0

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help to call Oracle Stored Funciton from ASP3.0 [message #195034]

Tue, 26 September 2006 12:36

KTZ
Messages: 15
Registered: January 2005

Junior Member

Can anyone help with calling an Oracle stored function? Or procedure? I read somewhere that functions are not callable from ASP - that you need to wrap it in a stored proc. I have tried both. Can't get either to work. I am using a command object. Code follows. The error I am getting is the same for both proc & fcn:

ORA-06550: line 1, column 7: PLS-00201: identifier 'EDS.P_EMPITEMLISTCHECKWRAPPER' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Both wrapper and function compile and run in TOAD. lngItemID has a valid interger value when the stored proc is called.

Here is code from ASP page:

Code:set objCmd= Server.CreateObject("ADODB.Command") 
with objCmd
	dim objParm1, objParm2
        .ActiveConnection = objConn
	.CommandType = adCmdStoredProc
	.CommandText = "EDS.P_EmpItemListCheckWrapper"
	Set objParm1 = objCmd.CreateParameter("ItemNum", adInteger, adParamInput, , lngItemID)
        objCmd.Parameters.Append objParm1
	Set objParm2 = objCmd.CreateParameter("Out1", adVarChar, adParamOutput, 5)
	objCmd.Parameters.Append objParm2
	.Execute
	blnOKToInactivate=.objCmd("Out1")
end with

Report message to a moderator