RE: Calling an External Java Class from PL/SQL

From: Vadim Gorbounov <vgorbounov_at_724.com>
Date: Wed, 15 May 2002 11:14:36 -0800
Message-ID: <F001.004616F6.20020515111436@fatcity.com>

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
pnbarne_at_regence.com

---

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: regdba_at_yahoo.com

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: ListGuru_at_fatcity.com (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: vgorbounov_at_724.com

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: ListGuru_at_fatcity.com (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). Received on Wed May 15 2002 - 14:14:36 CDT