vb oracle PLEASE HELP!!!!!

[nexus]

hi,

is there any way of creating a stored procedure in the data enviroment and getting it to return a recordset
im currently using mdac 2.5 witch supports this.
but the only way i can get this to work is to create a package in pl/sql save it to the database and use ado to call the procedure from the package witch returns the cursor.(pants!!!)

what i want is to use the data enviroment and create a stored procedure witch will return a record set as you do with sql server 7.0

can this be done (changing to sql server is not an answer im looking for cus im tied to oracale 8i)

if so how!!!!!!

many thanx in advance!

[JHausmann]

You should be able to create a stored procedure in code and submit it to Oracle Server for storage (this can be done in SQL server). Once you've created the stored procedure (transaction #1), you can run it (transaction #2 - n).