| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Calling an External Java Class from PL/SQL
You can call them by building a wrapper in the Java in DB and have it call
the external procedure. You can expose that internal Java to the PL/SQL
RTFM and get back with any further queries. The Oracle Java documents have quite a bit of useful info on this
Cheers
--
Peter McLarty E-mail: Peter.Mclarty_at_mincom.com Technical Consultant WWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia Mobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 =================================================A great pleasure in life is doing what people say you cannot do.
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
Vadim Gorbounov <vgorbounov_at_724.com>
Sent by: root_at_fatcity.com
16-05-2002 05:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Fax to:
Subject: RE: Calling an External Java Class from PL/SQL
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
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.
--=_mixed 002601C54A256BBB_=--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Peter.McLarty_at_mincom.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |