Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I execute a stored procedure that is part of a package?

Status
Not open for further replies.

TWillard

Programmer
Apr 26, 2001
263
US
I need to know if I can execute an Oracle stored procedure that is with in a package from ASP. I have successfully executed other stored procedures in several of my previous pages. However, this is my first attempt to call one that is within a package and I am having troubles. My pseudocode looks like the following:

set datacomm = server.createobject("ADODB.Command")
set datacomm.ActiveConnection = dataconn
datacomm.commandtype = adCmdStoredProc
datacomm.commandtext = "pkg_name.procedure_name"

....add/set params....

datacomm.execute (recs)

Thank you for taking the time to read my post!
 
I have not yet finished my problem. However, I just thought I would post for reference, that YES one can call a stored procedure within a package.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top