	AllExperts > Experts
	Search

Ask a question about Active Server Pages Programming (ASP)
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

About kevin maloney
Expertise
fairly decent overall understanding of active server pages and related client-side programming.

You are here: Experts > Computing/Technology > Business Software > Active Server Pages Programming (ASP) > ASP called Oracle Stored Procedure

Active Server Pages Programming (ASP) - ASP called Oracle Stored Procedure

Expert: kevin maloney - 11/29/2004

Question
Hi Kelvin,

I am trying to call a stored procedure using ASP and I got the following error at the execute:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-20004:
/dps/intake/CaseAdmitEdit.asp, line 217

Set CMD = Server.CreateObject("ADODB.Command")
CMD.ActiveConnection   = objConnect
CMD.CommandText   = "SP_CREATE"
CMD.CommandType   = adCmdStoredProc
CMD.Parameters.Append CMD.CreateParameter("p_HomeCd",adVarChar, adParamInput, 4, tHomeCd)
CMD.Parameters.Append CMD.CreateParameter("p_RetValue", adVarChar, adParamOutput, 300)CMD.Execute

What can be wrong?

Answer
Hi --

That error would typically occur if the current oracle user doesn't have the authority to execute the SP_CREATE stored procedure. To test, try to login to SQL-plus using the same userid and password combination, and execute the same commands inside Oracle directly.

Other than that, not sure what to suggest.

Add to this Answer Ask a Question

About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.