Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, jaydeep.

Asked: July 31, 2017 - 10:58 am UTC

Last updated: August 04, 2017 - 2:04 am UTC

Version: oracle 11g

Viewed 10K+ times! This question is

You Asked

Could you please provide an example that
1) Loads a jar file into oracle [any permissions and path variables that needs to be set-up using DBAs help]
2) Load a class that uses the above jar file
3) Create a PL/SQL procedure or function that uses the above class file

I tried looking online and found multiple bits and pieces of information but there is no clear explanation of all the steps involved that can be followed. So if you could provide an example with a simple functionality, of a java class using jar files which can be invoked from PL/SQL, it would be great.

and Connor said...

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

great links

jaydeep cheruku, August 02, 2017 - 1:06 am UTC

Thanks Connor for the links, but is there an example where it explains how to load jar files?

I used "loadjava -verbose -u username/password -jarasresource -genmissing -resolve file.jar" but some of the classes failed to load. I used the same jar files in eclipse and it worked with out any issues.

Connor McDonald
August 04, 2017 - 2:04 am UTC

See the 4th link

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library