OracleDatabase/VB

[rajender]

I am working with Oracle as back end for VB.I have written stored procedure in which I am getting rowtype. I have rowtype(from Oracle) ie record set in VB . Iam trying to get that as out parameter in VB. I am not able to access to that out parametere in VB. How do I acces that. is there any
datatype in VB same as that of rowtype.

[Chris Eastwood]

Hi

The only data access method that I know of that lets you return a Cursor from
a stored procedure in Oracle is Oracle Objects for OLE (OO4O). I think this comes
free with the Oracle Client software (or the Server - can't remember off hand).

Microsoft did write up a work around to still let you use ADO/RDO/DAO to get cursors
from resultsets (well, not really cursors). Basically, you have your StoredProcedure
return an Array which is built up from the Rows/Columns in the cursor.

Search the MSDN at http://msdn.microsoft.com for 'Oracle' 'Stored Procedures'
and you should find the article.

I know it's a real pain - we (the Developers) here wanted to use SQL server (nice and
easy integration with VB), but we had to go along the OO4O route to get the application
working properly.

Regards

Chris Eastwood

CodeGuru - the website for developers
http://www.codeguru.com/vb