This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes Can you invoke a Java class from a PL/SQL stored procedure? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Can you invoke a Java class from a PL/SQL stored procedure?" Watch "Can you invoke a Java class from a PL/SQL stored procedure?" New topic
Author

Can you invoke a Java class from a PL/SQL stored procedure?

SAFROLE YUTANI
Ranch Hand

Joined: Jul 06, 2001
Posts: 257
I have a stored procedure in Oracle that runs automatically at 2AM every night. If the procedure can determine a certain condition, then it must email someone and notify them. If I have a java class that provides features to send an email message, can I invoke the class from the stored procedure?
SAF
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/java.817/a83728/04jserv1.htm#1006139
Jamie
SAFROLE YUTANI
Ranch Hand

Joined: Jul 06, 2001
Posts: 257
Thanks Jamie, that was a big help.
My other problem is trying to figure out how to pass an argument through PL/SQL to a Java class. I need to pass a String type, so it's primiive enough to not cause me so much headache, I hope!
Thanks again,
SAF
 
GeeCON Prague 2014
 
subject: Can you invoke a Java class from a PL/SQL stored procedure?