error in redaing clob record [message #231217] |
Mon, 16 April 2007 01:13 |
ammishra
Messages: 179 Registered: January 2007 Location: india
|
Senior Member |
|
|
Hi,
i am getting error to reading clob data type ...
declare
out_xml clob;
l_buffer RAW(20000);
l_text_buffer VARCHAR2(32767);
nOffset number := 1;
iMaxSize integer := 32767;
iclobSize integer;
vBuffer varchar2(32767);
begin
select a.RTF_FILE_DATA into out_xml from erat_report_rev_details a where rownum<2;
iclobSize := dbms_lob.getlength(out_xml);
dbms_lob.read(out_xml, iMaxSize, nOffset, vBuffer);
dbms_output.put_line(iclobSize||vBuffer);
end;
i am getting fallowing error.
declare
out_xml clob;
l_buffer RAW(20000);
l_text_buffer VARCHAR2(32767);
nOffset number := 1;
iMaxSize integer := 32767;
iclobSize integer;
vBuffer varchar2(32767);
begin
select a.RTF_FILE_DATA into out_xml from erat_report_rev_details a where rownum<
--DBMS_LOB.READ(out_xml,iMaxSize,nOffset ,l_buffer);
--l_text_buffer := UTL_RAW.CAST_TO_VARCHAR2(l_buffer);
iclobSize := dbms_lob.getlength(out_xml);
dbms_lob.read(out_xml, iMaxSize, nOffset, vBuffer);
dbms_output.put_line(iclobSize||vBuffer);
end;
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_OUTPUT", line 57
ORA-06512: at line 19
--Yash
|
|
|
|
|