dbms_lob.substr does not handle more than 4000 chars from a select statemen
567078Nov 30 2007 — edited Nov 30 2007declare
type a is record ( b varchar2(7000));
x a;
cur sys_refcursor;
begin
open cur for
select dbms_lob.substr(raw_message,4001,1) raw_message
from ca_custodian_msgs_raw where curw_tag=40967;
fetch cur into x;
end;
/
The above snipper works till 4000 chars but not above that. any workaround? i am going to return this substr result as part of a ref cursor, this is just a simulation.
Thanks
Ram