Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How can I setup and use loadjava utility without installing oracle database? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I setup and use loadjava utility without installing oracle database?

Received Response
7
Views
2
Comments
edited Apr 16, 2022 7:51AM in Autonomous Database 2 comments

Summary

How can I setup and use loadjava utility without installing oracle database?

Content

Is there a way at all and if yes, then how to enable java code calling/execution from within PL/SQL procedure running on an ATP instance?

My understanding is that it is possible to do  by loading the compiled java class into a respective database schema and creating a PL/SQL wrapper function. But in ATP case this route seems untenable as I don't have access to OS, and hence the dB utilities and file system in general.. I am thinking that this should still be possible by using the same loadjava utility running on a different computer and loading a java class into the remote ATP schema. But how do I get a hold of loadjava utility only without the whole hassle of installing an Oracle dB?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!