Oracle Procedures?

This topic is locked

Oracle Procedures?	1/2/2007 10:53:50 AM
ASPRunnerPro General questions
C carleydc author Can I call a Procedure or package from Oracle in an OnLoad event? I have many packages created in Oracle that return data I need with Cursors. Can I call one of my procedures from an event? Like... set rstmp = Server.CreateObject("ADODB.COMMAND") rstmp.open "NTCTEST.STATS(o_cnt);", dbConnection 'Session("cntField1") = rstmp("i_cnt") Or... strSQLProc = "NTCTEST.STATS(o_cnt);" dbConnection.Execute strSQLProc Session("Comp_cnt") = strSQLProc("i_cnt") Niether of the above work calling a procedure is it possible with some different syntax?

Mark as Solved Mark as not solved

3 replies


	Sergey Kornilov admin 1/2/2007
	Probably this article can help: http://www.learnasp.com/freebook/asp/FAQOr...storedproc.aspx


C	carleydc author 1/5/2007
	Probably this article can help: http://www.learnasp.com/freebook/asp/FAQOr...storedproc.aspx Thanks for the tip. I think I am a bit closer but I now get this message do you know what it means? Technical information Error number 3709 Error description Requested operation requires an OLE DB Session object, which is not supported by the current provider. I used either a DSN to Oracle via MS and Oracles ODBC Driver. If this helps.


	Sergey Kornilov admin 1/7/2007
	I guess you can find in newsgroups or forums related to ASP and Oracle.

3 replies

Mark as Solved Reply