Re: CLOB

A copy of this was sent to Gabriel Millerd <millerd_at_ns1.rli-net.net> (if that email address didn't require changing) On 3 Dec 1999 22:25:08 GMT, you wrote:

>i have having problems accessing data in CLOB columns. inserts work great, but selecting them does not. any one point me in the right direction?
>
>thanks

have an example of what you are trying to do? what language you are trying to do it in?

If you are writing stored procedures, the dbms_lob package does piecewise reads/writes on all lobs easily.

if you are using just sql and want 4000 bytes of it, "select dbms_lob.substr(lob_col,4000,1) from T" gets that (4000 bytes will be the max in SQL). in other languages you have to see how to bind to a lob and then use the api calls to read pieces of it.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Dec 04 1999 - 07:51:20 CST