Get the LENGTH of a LONG RAW
I don’t think it’s possible to manipulate LONG RAWs longer than 32k in PLSQL. Here is a java procedure that returns the length of a LONG RAW. First, the setup: SQL> CREATE TABLE my_table (ID NUMBER, my_long_raw_column LONG RAW); Table created SQL> INSERT INTO my_table VALUES (1, utl_raw.cast_to_raw(‘123456789’)); 1 row inserted The java class (my … Read more