Rem
Rem $Header: admin_loadjava.sql 13-mar-2003.15:48:46 rpinnama Exp $
Rem
Rem admin_loadjava.sql
Rem
Rem Copyright (c) 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      admin_loadjava.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    rpinnama    03/13/03 - rpinnama_createrep_updates
Rem    rpinnama    02/25/03 - Created
Rem

Rem 
Rem This requires the following SQL*Plus arguments
Rem 1. Directory that contains the jar file to be loaded
Rem 2. Jar file to be loaded
Rem 3. user name for which grants have to be created.
Rem

define jar_dir    ="&1"
define jar_file   = "&2"
define grant_user = "&3"

Rem 
Rem Options to loadjava
Rem  -v verbose
Rem  -r resolve
Rem  -synonym 
Rem  -grant "repos_user"

call dbms_java.loadjava('-v -f -r -synonym -grant ' || '&grant_user' || ' ' || '&jar_dir' || '/' || '&jar_file');