Re: PL/SQL-Functions called with ADO return random junk

>> I am calling several PL/SQL-Functions that return VarChar2-Data.
>> The first time I call any function, everything is alright. However
>> the second (and subsequent times) I call that function and the
>> return value is shorter than the previous value, some random junk
>> and fragments of the previous value are appended to the correct
>> result.

> I tested your code with Oracle 10.2.0.4 and the 11.1.0.6 client using
> Microsoft Excel 2007. I did not have unexpected results.

Thank you! So it looks like our old 8.1-Client is to blame.

> There is a chance that the older Oracle client is returning a null
> terminated string - in other words, the client application is supposed
> to search the returned value for Chr(0), and retain only what is to
> the left of the Chr(0) (this is a standard for several Windows API
> calls which return strings):

I don't think so. I've done this before with Oracle 7.x- and 8.x-Clients and that has never been the case.

Regards
Philipp Received on Wed Aug 26 2009 - 03:55:08 CDT