EBS Customizations (MOSC)

MOSC Banner

How to embed java class in a PL/SQL procedure

edited Sep 17, 2012 12:06AM in EBS Customizations (MOSC) 3 commentsAnswered
We have a custom database package xx_fileutils which includes the procedure
PROCEDURE MOVEFILE (fromFile IN VARCHAR2, toFile IN VARCHAR2, errmsg IN OUT VARCHAR2);

the package body is
 PROCEDURE MOVEFILE (fromFile IN VARCHAR2, toFile IN VARCHAR2, errmsg IN OUT VARCHAR2)
    AS LANGUAGE JAVA
    NAME 'xx_java_fileutils.FileUtilities.moveFile(java.lang.String, java.lang.String, java.lang.String[])';
   
I would like to know
1)if the code for the java class is held anywhere in any database tables or in the filesystem and is available for viewing
2)How to create a PL/SQL wrapper around a java class so that it can be invoked from a database package procedure

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center