aspose file tools*
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can you invoke a Java class from a PL/SQL stored procedure?
 
Similar Threads
Java Stored Procedure
Stored Procedures and Session Ejb
Can we call java program from a Oracle stored procedure?
Performance of fomatting string : Java vs Database.
Packed decimal conversion - Java