Hi,

Recently upgraded MDAC on server and now a simple query that looks up a value on a linked Oracle database doesn't work. This lookup happens as part of a transaction and what I noticed is that if I do lookup outside of the transaction it works fine. Example 1 below works fine but example 2 gives following error:

OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: ORA-01084: invalid argument in OCI call
]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IRowset::GetNextRows returned 0x80004005: ].


Example 1:
DECLARE @ref_nb varchar(255)
DECLARE @ref_nb_ora varchar(255)
SELECT @ref_nb='123456789'
SELECT @ref_nb_ora=CASE WHEN ORDID IS NULL THEN ORDERID ELSE ORDID END from SERV..ER1.VW_ACCOUNT_ORD_2 where TRANS_ID =@ref_nb

Example 2:
BEGIN TRANSACTION
DECLARE @ref_nb varchar(255)
DECLARE @ref_nb_ora varchar(255)
SELECT @ref_nb='123456789'
SELECT @ref_nb_ora=CASE WHEN ORDID IS NULL THEN ORDERID ELSE ORDID END from SERV..ER1.VW_ACCOUNT_ORD_2 where TRANS_ID =@ref_nb
ROLLBACK

Any help would be appreciated.

Thanks
David