The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
Thanks for the question, Giri.
Asked: February 06, 2025 - 6:59 am UTC
Last updated: May 08, 2025 - 2:02 am UTC
Version: oracle 21c express edition
Viewed 1000+ times
SQL> create table t ( b blob ); Table created. SQL> SQL> declare 2 digits raw(1000) := hextoraw(rpad('FF',1000,'FF')); 3 4 l_blob blob; 5 begin 6 insert into t values ( empty_blob()) 7 returning b into l_blob; 8 9 dbms_lob.writeappend(l_blob,length(digits)/2,digits); 10 dbms_lob.writeappend(l_blob,length(digits)/2,digits); 11 dbms_lob.writeappend(l_blob,length(digits)/2,digits); 12 dbms_lob.writeappend(l_blob,length(digits)/2,digits); 13 end; 14 / PL/SQL procedure successfully completed. SQL> SQL> select dbms_lob.getlength(b) from t; DBMS_LOB.GETLENGTH(B) --------------------- 2000
Giri K, February 14, 2025 - 10:21 am UTC
A reader, February 17, 2025 - 7:49 am UTC
Slope Game, March 17, 2025 - 8:22 am UTC
Drew Binsky, May 07, 2025 - 10:40 am UTC
Complete documentation on Securefiles and Large Objects here