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"![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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!
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!