My name is Cristi=E1n and I bought a copy of the book "Profesional ADO 

2.1 RDS Programing with ASP".

    On chapter 15 explain how to get a recordset from an oracle package.

    How can I get a recordset from an oracle package with input 

parameters from an ASP Page? 

Hi

I use run on Oracle 8i and this is what I use...Enjoy!!!









'Set Session("DBConn") = Server.CreateObject("ADODB.Connection")

		'Session("DBConn").Open "SERVER=ODBHQ1;DRIVER={Microsoft ODBC for 

Oracle};UID=BATCH;PWD=BATCH;"

		Set RS = Server.CreateObject("ADODB.Recordset")

		Qry = "SELECT * FROM history_type, batch_type,item_type WHERE 

batch_type.batch_type_id= '" & session("BTI") & "' AND 

item_type.item_type_id = '" & session("BI") & " '"

		RS.open Qry, Session("DBConn"), 3, 3