Name
CREATE/ALTER/DROP JAVA
Synopsis
CREATE Syntax:
CREATE [OR REPLACE] [AND {RESOLVE | COMPILE}] [NOFORCE]
JAVA
{ {SOURCE | RESOURCE} NAMED [schema.]object_name
| CLASS [SCHEMA schema]
}
[AUTHID {CURRENT_USER | DEFINER}]
RESOLVER ((match_string[,]{schema_name | -})[(match_string...)])]
{ USING
{BFILE (directory_object_name,server_file_name)
| { BLOB subquery
| CLOB
| BFILE
}
| 'key_for_BLOB'
}
|
AS source_text
}ALTER Syntax:
ALTER JAVA
{SOURCE | CLASS} [schema.]object_name
[RESOLVER ((match_string[,]{schema_name | -})[(match_string...)])]
{COMPILE | RESOLVE}
[AUTHID {CURRENT_USER | DEFINER}]DROP Syntax:
DROP JAVA {SOURCE | CLASS | RESOURCE} [schema.]object_nameCreates an object containing a Java source, class, or resource; or forces the resolution of a Java class schema object or the compilation of a Java source schema object; or removes a Java object from the database. New with Oracle8i.
Keywords
- OR REPLACE
Specifies that the Java object is to be replaced if it already exists.
- RESOLVE | COMPILE
Specifies that Oracle should attempt to resolve the Java schema object that is created. The two keywords have identical meaning and are interchangeable.
- NOFORCE
Specifies that the results of this statement are to be rolled back if RESOLVE or COMPILE is specified and the resolution fails.
- SOURCE
Specifies that a Java source file is to be loaded.
- RESOURCE
Specifies that a Java resource file is to be loaded.
- object_name
Name of the schema object in which source code is held or which should hold ...