How to embed java class in a PL/SQL 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