Show Java source file : DBMS_LOB « System Packages « Oracle PL/SQL Tutorial

SQL>
SQL> CREATE OR REPLACE PROCEDURE show_java_source (
  2     name IN VARCHAR2,
  3     schema IN VARCHAR2 := NULL
  4  )
  5  IS
  6     b CLOB;
  7     v VARCHAR2 (2000);
  8     i INTEGER;
  9  BEGIN
 10     DBMS_LOB.createtemporary (b, FALSE);
 11     dbms_java.export_source (name, NVL (schema, USER), b);
 12     i := 1000;
 13     DBMS_LOB.read (b, i, 1, v);
 14     DBMS_OUTPUT.put_line (v);
 15  END;
 16  /

Warning: Procedure created with compilation errors.

SQL>
SQL>
SQL>

31.12.DBMS_LOB
	31.12.1.	DBMS_LOB Package
	31.12.2.	Print clob data out
	31.12.3.	Use dbms_lob.getlength to get the length of a clob data
	31.12.4.	Show Java source file
	31.12.5.	Use dbms_lob package to deal with clob data
	31.12.6.	Use dbms_lob.getlength and dbms_lob.substr with blob type column
	31.12.7.	Use dbms_lob.substr to get part of clob data
	31.12.8.	DBMS_LOB.READ
	31.12.9.	Load a file