DBMS_JAVA.LOADJAVA syntax.....
382331Jul 30 2004 — edited Aug 18 2004While using the command line loadjava-utility to load my Java stored procedures into a 9.2 database I use an absolute file path to specify the java source file. This works fine.
However, when attempting to use the DBMS_JAVA.LOADJAVA utility to load the very same stored proc from SqlPlus it doesn't work. No error message is generated! I suspect that it has something to do with how i specify the file path. I've tried running it from a client computer, and from the server. I've attempted to use both relative and absolute paths, with and without a $ORACLE_HOME prefix.... But nothing works!
I'm operating in Windows environments only.
...and the Oracle documentation is not very helpful either as it mainly addresses the command-line utility:)
Has anyone figured this one out??