ALTER JAVA

Syntax

invoker_rights_clause::=

Purpose

To force the resolution of a Java class schema object or compilation of a Java source schema object. (You cannot call the methods of a Java class before all its external references to Java names are associated with other classes.)

See Also: Oracle8i Java Stored Procedures Developer's Guide for more information on resolving Java classes and compiling Java sources.

Prerequisites

The Java source or class must be in your own schema, or you must have the ALTER ANY PROCEDURE system privilege. You must also have the EXECUTE object privilege on Java classes.

Keywords and Parameters

JAVA SOURCE	compiles a Java source schema object.
JAVA CLASS	resolves a Java class schema object.
object_name	specifies a previously created Java class or source schema object. Use double quotation marks to preserve lower- or mixed-case names.
RESOLVER	specifies how schemas are searched for referenced fully specified Java names, using the mapping pairs specified when the Java class or source was created. See Also: "CREATE JAVA".
RESOLVE | COMPILE	are synonymous keywords. They specify that Oracle should attempt to resolve the primary Java class schema object. When applied to a class, resolution of referenced names to other class schema objects occurs. When applied to a source, source compilation occurs.
invoker_rights_clause	specifies whether the methods of the class execute with the privileges and in the schema of the user who defined it or with the privileges and in the schema of CURRENT_USER. For information on how CURRENT_USER is determined, see Oracle8i Concepts and Oracle8i Application Developer's Guide - Fundamentals. This clause also determines how Oracle resolves external names in queries, DML operations, and dynamic SQL statements in the member functions and procedures of the type. See Also: Oracle8i Java Stored Procedures Developer's Guide.
	AUTHID CURRENT_USER	specifies that the methods of the class execute with the privileges of CURRENT_USER. This clause is the default and creates an "invoker-rights class." This clause also specifies that external names in queries, DML operations, and dynamic SQL statements resolve in the schema of CURRENT_USER. External names in all other statements resolve in the schema in which the methods reside.
	AUTHID DEFINER	specifies that the methods of the class execute with the privileges of the user who defined it. This clause also specifies that external names resolve in the schema where the methods reside.

Example

The following statement forces the resolution of a Java class:

ALTER JAVA CLASS "Agent"
   RESOLVER (("/home/java/bin/*" scott)(* public))
   RESOLVE;