Re: Problem with OCI, NON_BLOCKING_MODE and OUT parameters
Date: Mon, 20 Oct 2003 23:26:06 +0100
Message-ID: <1iZkb.1927$bD.8301_at_news.indigo.ie>
Check the maximum length of a varchar2 pl/sql variable for your Database
version.
as far as I can remember, in Oracle 8.05 its 2K but goes up to 4K in 8.17
"PM" <p.matysiak_at_wonlok.com.pl> wrote in message
news:bn045d$fcv$1_at_kujawiak.man.lodz.pl...
> Hi
>
> I've got a procedure in PL/SQL with VARCHAR2 OUT parameter.
> My client is written in Delphi. I use Net v.8.0.6.
> When I call this procedure from Delphi in NON_BLOCING_MODE,
> and there is a short value (1K) in this parameter, everything is OK,
> but if value is longer (2K and more) - I get "Acces Violation" in
> ora805.dll.
>
> If I use Net v.8.0.5 or Net v.8.0.7 - everything is OK.
>
> Could someone give me some help on this please?
>
> Thanks, Piotro
>
>
>
Received on Tue Oct 21 2003 - 00:26:06 CEST