Accessing Oracle 7.1.2 Stored Procedures from ASP. Help needed.
Date: Sat, 27 Mar 1999 21:35:46 -0500
Message-ID: <OvhL2.286$kt2.3204_at_news.megsinet.net>
Hi:
I am developing an ASP application which accesses an Oracle 7.1.2 database. This is no longer supported by Oracle so finding help there is difficult. I am using the Oracle ODBC drivers included with a later version of their client access software and Oracle Objects for OLE. I have tried using the Microsoft ODBC driver and cannot even connect to the database. I can connect to the database fine wit the Oracle ODBC driver but when I try to execute a Stored Procedure Oracle complains about the Parameters being invalid. However this works on a newer version. I cannot move the databse to a newer version until the application is developed. The Oracle database is running on a Sequent box.
Does anyone know if I can do this with ASP with this old a version of Oracle, and if so what driver version should I use.
Here is an example of the kind of thing I am trying to do.
<%_at_ Language=VBScript %> <HTML> <BODY> <%
Set OraSess =Server.CreateObject("OracleInProcServer.XOraSession") 'Create object
Set OraDb
=OraSess.DbOpenDatabase("databasename","username/password",Clng(0)) 'Open Connection
' defining and assigning value "test1" for first parameter input1
OraDb.Parameters.Add "input1", "test1",1
'Assign the servertype to parameter
OraDb.Parameters("input1").ServerType = 96
' defining and assigning value "1111" for seconds parameter input2
OraDb.Parameters.Add "input2", "1111",1
OraDb.Parameters("input2").ServerType =2
'defining output parameter outpu1 with value 0, this is in/out parameter
OraDb.Parameters.Add "output1",0,3
OraDb.Parameters("output1").ServerType=2
OraDb.DBExecuteSQL ("Begin testProcedure(:input1,:input2,:output1); end;")
output1_str = OraDB.Parameters("output1").Value
Set OraDb = nothing
Set OraSess = nothing
%>
output1 Value : <%=output1%><br>
<hr> </BODY> </HTML>
Any help will be greatly appreciated.
Thankyou in advance.
Christopher Thomas
cthomas1_at_megsinet.net
Received on Sun Mar 28 1999 - 04:35:46 CEST