Skip to Main Content

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_JAVA.LOADJAVA syntax.....

382331Jul 30 2004 — edited Aug 18 2004
While 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??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2004
Added on Jul 30 2004
4 comments
9,775 views