Re: problem reading CLOB columns

Clobs have to be converted to buffers to be read in most tools. If you program in OCI you can use the locator directly, most tools do not support the direct read of CLOBs since this is a newer data type.

You have a couple of options:

1. You can use a stored procedure to return the clobs as 32k-1 buffers since this is the limit on PL/SQL VARCHAR2 types (much bigger than the SQL limit of 4000 bytes).
2. If the clob needs to be return in a cursor, you will need to break it up into pieces using DBMS_LOB.SUBSTR, because cursors can only return SQL types.

"Tomasz Bech" <tbech_at_POP.GO2.PL> wrote in message news:3AB1CE32.7C314BDA_at_POP.GO2.PL...
> Hi,
> I have Oracle Net8.1.6 and the same server version. When I try to
> read
> the CLOB columns (using several tools) I receive ORA-03120. And itt
> seems to me that it is not ODBC driver but Net8 problem.
> (in version 8.1.5 it was working, but not perfectly)
> What's wrong?
> Tomasz
>
>
>
>
Received on Mon Mar 19 2001 - 21:38:45 CST