Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

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_name

Creates 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page