Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Accessing Oracle 7.1.2 Stored Procedures from ASP
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.
<%@ Language=VBScript %> <HTML> <BODY> <%
' 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 Sat Mar 27 1999 - 20:33:55 CST