top of page
CerebroSQL

Oracle:

CREATE JAVA

CREATE [ OR REPLACE ] [ AND { RESOLVE | COMPILE } ] [ NOFORCE ]
JAVA { { SOURCE | RESOURCE } NAMED [ schema. ] primary_name
| CLASS [ SCHEMA schema ]
}
[ invoker_rights_clause ]
[ RESOLVER ( (match_string [,] { schema_name | - })...) ]
{ USING { BFILE (directory_object_name, server_file_name)
| { CLOB | BLOB | BFILE } subquery
| 'key_for_BLOB'
}
| AS source_char
} ;

invoker_rights_clause::=
AUTHID { CURRENT_USER | DEFINER }

example

CREATE JAVA CLASS USING BFILE (java_dir, 'Agent.class')

CREATE JAVA SOURCE NAMED "Welcome" AS
public class Welcome {
public static String welcome() {
return "Welcome World"; } }

CREATE JAVA RESOURCE NAMED "appText"
USING BFILE (java_dir, 'textBundle.dat')

bottom of page