| 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: How should I connect to BEA Weblogic from a pl/sql procedure and is this a stable connection.
Jaco
One approach might be to create a Java procedure in your database. Your PL/SQL could call this, and in turn it could access your Java service. I think the methods for PL/SQL to call a Java procedure are pretty well documented. But you may find the performance may not meet your expectations. There are probably several alternative configurations, so keep your mind open.
There aren't too many Java developers on this forum in my experience (but many of us are Java victims). Consider going to forums.oracle.com and asking your question on a Java forum. My guess is that you are more likely to find people that develop Java and PL/SQL for Oracle.
Dennis Williams
DBA
Lifetouch, Inc.
"We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive." -- C.S. Lewis
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of J.Polet_at_Robeco.nl
Sent: Wednesday, August 18, 2004 2:12 AM
To: oracle-l_at_freelists.org
Subject: Re: How should I connect to BEA Weblogic from a pl/sql
procedure and is this a stable connection.
Dennis,
Thanks for your reply.
> Jaco - I saw you received one reply. Did this answer your question? I
> briefly discussed your question with my WebLogic administrator and he
felt
> you needed to clarify what you are trying to do. Are you trying to start
> Weblogic, or connect to an application that is running under Weblogic?
> Normally Oracle acts as a resource for WebLogic, so the normal connection
> goes from WebLogic to Oracle.
I have missed the one reply you mentioned and I couldn't find it in the
archive.
To clarify my question:
We are trying to start an application that is running under Weblogic.
An example might make it clear:
In Weblogic we have a program (we call it a service) which validates an
address / zipcode combination.
In Oracle we have a pl/sql procedure which inserts a customer together with
his/hers address and zipcode in a table. Within this procedure we would
like to test whether the combination address and zipcode is valid by using
the service in weblogic.
I hope this carifies my question.
Jaco
(Embedded image moved to NL Telephone: +31 (0) 10 224 2045
file: pic12623.gif)Robeco E-mail: J.Polet_at_robeco.nl
Jaco Polet
Corporate ICT/BS DBA
-- Binary/unsupported file stripped by Ecartis --
-- Type: image/gif
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Aug 18 2004 - 08:09:21 CDT
 |
 |