Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Does anyone know how to access a lob remotely?
Using the following
procedure, I'm getting a ora-22992 error.
<SPAN
class=633033700-11122001>
<SPAN
class=633033700-11122001>declare locator_var clob; amount_var
number; offset_var number; output_var
varchar2(20);begin amount_var:=16; offset_var:=1; buffer_var:='This
is not text'; select b into locator_var from
lob_test_at_to_features where a =
1; dbms_lob.READ(locator_var,amount_var,offset_var,output_var); output_var:=nvl(output_var,'asd'); dbms_output.put_line('start
of CLOB: '|| output_var);end;
<SPAN
class=633033700-11122001>
I've looked in
metalink and found note:119897.1 but it does not help me very
much..
<SPAN
class=633033700-11122001>
Anyone have any
ideas?
<SPAN
class=633033700-11122001>
<SPAN
class=633033700-11122001>Nick
Received on Mon Dec 10 2001 - 19:06:06 CST