Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Temporary securefile LOB

Jan LeersFeb 23 2011 — edited Feb 23 2011
Is it possible to create a securefile lob in PL/SQL to use the new dbms_lob procedures

Following block gives: "ORA-43856: Unsupported LOB type for SECUREFILE LOB operation"

DECLARE
l_clob clob;
BEGIN
l_clob := '1234';
dbms_lob.fragment_replace(lob_loc => l_clob
,old_amount => 2
,new_amount => 2
,offset => 2
,buffer => 'BC');
END;
This post has been answered by Tubby on Feb 23 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2011
Added on Feb 23 2011
4 comments
792 views