Re: ADORecordset

From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Tue, 16 Jan 2001 18:12:16 -0000
Message-ID: <942338$b7h$1@kermit.esat.net>

Loads of success after months of trials and tribulations(ADO 2.5). There are some basic rules:

i) You must return the recordset using a ref_cursor. This necessitates the use of a package.ref_cursor must be last in parameter list.
I have alos found it better to have strongly typed ref cursor.

ii) don't have chars and pls_integers in any parameters

iii) set resultset to null after you finish retrieving results, otherwise dreaded max_open_cursors error.

news.optusnet.com.au wrote in message
<3a643ef5$0$15497$7f31c96c_at_news01.syd.optusnet.com.au>...
>I saw serious problems with MS MDAC 2.6 - with any other version it should
>work fine.
>
><amw157_at_aol.com> wrote in message news:93fvgd$aqe$1_at_nnrp1.deja.com...
>> Has anyone had any success using ADO with an Oracle database? I'm
>> having some serious problems with getting the syntax right. Can
>> someone help me out? I need to open some ADORecordsets on an Oracle
>> database and I am coming up empty handed.
>>
>> Andy
>> amw157_at_aol.com
>>
>>
>> Sent via Deja.com
>> http://www.deja.com/
>
>
Received on Tue Jan 16 2001 - 12:12:16 CST