DCOracle and handling of package OUT parameters broken ?!

[Oleg Broytmann]

On Wed, 17 May 2000, Graham Bleach wrote:
> > oci.error: (6502, 'ORA-06502: PL/SQL: numeric or value error: character
> string buffer too small\012ORA-06512: at "AJUNG.SELECT_LOB", line
> 22\012ORA-06512: at line 2\012')
> 
> Hmm, this looks like the buffer mentioned above is the OCI buffer
> used/created by DCOracle. I'm not familiar with DCOracle (not enough time).
> Is there anything that's specifically designed to handle CLOBs being
> returned from Oracle?

   DCOracle (or may be OCI) cannot return LOB - you need to SELECT it
separately. For example, instead of returning the LOB, return ROW ID, and
then SELECT the row by ID.

Oleg.            (All opinions are mine and not of my employer)
---- 
    Oleg Broytmann      Foundation for Effective Policies      phd at phd.russ.ru
           Programmers don't die, they just GOSUB without RETURN.