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

From: Philipp Stiefel <>
Date: Wed, 26 Aug 2009 10:55:08 +0200
Message-ID: <>

Charles Hooper <> wrote:
> On Aug 25, 6:35 pm, Philipp Stiefel <> wrote:
>> 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 and the 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.

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

Original text of this message