set serveroutput on;
call dbms_java.set_output(50);

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "CREATE_BLOB_TEST" AS

package createBlobTest;

import java.sql.*;
import oracle.jdbc.*;
import oracle.jdbc.pool.*;

class CreateBlobTest {

                public static  Blob test() throws Exception {
                                Connection connection;
                                OracleDataSource ds;
                                String connectUrl = "jdbc:default:connection:";

                                ds = new oracle.jdbc.pool.OracleDataSource();
                                ds.setURL(connectUrl);
                                connection = (OracleConnection) ds.getConnection();

                                DatabaseMetaData dbmd = connection.getMetaData();
                                System.out.println("Database Version: " + dbmd.getDatabaseProductVersion() );
                                System.out.println("Driver Version: " + dbmd.getDriverVersion() );

                                return  connection.createBlob();
                }
}
/

CREATE OR REPLACE FUNCTION createblobtest RETURN BLOB AS
    LANGUAGE JAVA
    NAME 'createBlobTest.CreateBlobTest.test() return java.sql.Blob' ;
/

BEGIN
    dbms_output.put_line (dbms_lob.getlength (createblobtest ()));
END;
/

Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
Driver Version: 11.2.0.3.0
Exception in thread "Root Thread" java.lang.AbstractMethodError
at createBlobTest.CreateBlobTest.test(CREATE_BLOB_TEST:22)
BEGIN
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.AbstractMethodError
ORA-06512: at "SYS.CREATEBLOBTEST", line 1
ORA-06512: at line 2

Database Version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Driver Version: 12.2.0.1.0
0