DCOracle and handling of package OUT parameters broken ?!

[Drew Csillag]

On Wed, 17 May 2000, Andreas Jung wrote:

> On Wed, May 17, 2000 at 01:35:01PM +0000, Oleg Broytmann wrote:
> > 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.
> 
> I never tried this in my example! The LOB is read inside
> the stored procedure !
> 
> Andreas 

Alternatively, you could return a REF CURSOR with the CLOB in it and get
it from there.

Drew