Home » SQL & PL/SQL » SQL & PL/SQL » Help to call Oracle Stored Funciton from ASP3.0
Help to call Oracle Stored Funciton from ASP3.0 [message #195034] Tue, 26 September 2006 12:36 Go to next message
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 
Re: Help to call Oracle Stored Funciton from ASP3.0 [message #195044 is a reply to message #195034] Tue, 26 September 2006 13:52 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Are you connecting as a user other than EDS?

If so, that user will need the execute privilege on the function/procedure in the EDS schema.

[Updated on: Tue, 26 September 2006 13:52]

Report message to a moderator

Re: Help to call Oracle Stored Funciton from ASP3.0 [message #195229 is a reply to message #195034] Wed, 27 September 2006 08:35 Go to previous message
KTZ
Messages: 15
Registered: January 2005
Junior Member
Thanks. Such a simple thing! Embarassed Works fine now.
Previous Topic: Problem Generating XML File
Next Topic: Urgent Help on Long Raw
Goto Forum:
  


Current Time: Sun Dec 11 00:41:28 CST 2016

Total time taken to generate the page: 0.20556 seconds