Oracle and ADODB

From: Noel <harln_at_jlta.com.au>
Date: Wed, 6 Feb 2002 09:39:21 +0800
Message-ID: <jQ%78.14532$N31.698217@ozemail.com.au>

We're using ADO to call Oracle stored PL/SQL procedures and randomly get old data returned in a procedures output parameter but when it starts happening it seems to keep hapening for a while.

eg. we return some XML in cmd.Parameters(3) which may be
<Stuff>

<OtherStuff>ABC</OtherStuff>
<Stuff>

Later, in a different page and procedure we may return a value from cmd.Parameters(0) (which could be a file path). But the results are combined like..

C:\Path1\<Stuff><OtherStuff>ABC</OtherStuff><Stuff>Myotherpath\file.pdf

even if variables are freshly declared and unique.

I think it is related to the data types specified, does any one know where I can find specifications of data types between ADO and Oracle? Received on Tue Feb 05 2002 - 19:39:21 CST