Skip to Main Content
Forums

SQL & PL/SQL

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!

Java - PL/SQL Procedures and Functions?

921628Apr 15 2012 — edited Apr 16 2012
It's my understanding that Java can call PL/SQL stored procedures and functions and PL/SQL can call Java stored procedures and functions.

The reason I ask is that my company is reviewing the options on how to replatform our product. Our consultant stated that PL/SQL cannot access Java procedures. I believe they can. I'm not well educated in this, but I'm trying to learn as much as I can before we're committed.

Our GUI front-end will be written in Java, but they are still debating the back-end (large transaction batch jobs). Some think it should be written in Java, some state Java itself would be too slow. I did read AskTom's mantra - SQL, PL/SQL, Java, then C.

So, what's the scoop?

What's the preference, or best practice?
This post has been answered by unknown-7404 on Apr 16 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2012
Added on Apr 15 2012
21 comments
577 views