DCOracle and handling of package OUT parameters broken ?!

Andreas Jung ajung at sz-sb.de
Wed May 17 11:53:59 EDT 2000


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 




More information about the Python-list mailing list