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>