Hi, Pete, PL/SQL has an interface to built-in Oracle JServer. You can load "external class" here and call it, but at this point class is not external anymore, right? If you need access to the class on a different JVM - true external class, Java provides you RMI, EJB, Corba interfaces. Oracle implements these Java specifications in JServer, that is you can develop Java classes providing access to remote (i.e. external) classes, deploy these classes to Oracle JServer and create PL/SQL wrapper. URLs http://technet.oracle.com/docs/products/oracle9i/doc_library/901_doc/java.90 1/a90210/toc.htm http://technet.oracle.com/docs/products/oracle9i/doc_library/901_doc/java.90 1/a90187/toc.htm http://technet.oracle.com/docs/products/oracle9i/doc_library/901_doc/java.90 1/a90188/toc.htm
HTH Vadim -----Original Message----- Sent: Wednesday, May 15, 2002 1:53 PM To: Multiple recipients of list ORACLE-L We have a developer who has asked this question. How do you call an external java class from a pl/sql stored procedure? You can stick my knowledge of java in a thimble. Can this be done, if so can you point me to a url with an example or two. Thanks, Pete ===== Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
