Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Does anyone know how to access a lob remotely?

Does anyone know how to access a lob remotely?

From: Nick Wagner <Nick.Wagner_at_quest.com>
Date: Mon, 10 Dec 2001 17:06:06 -0800
Message-ID: <F001.003D968C.20011210163517@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US