Re: call java on application server from pl sql stored procedure

From: HansF <News.Hans_at_telus.net>
Date: Tue, 14 Jun 2005 15:20:47 GMT
Message-Id: <pan.2005.06.14.15.23.45.320489@telus.net>

On Tue, 14 Jun 2005 14:42:36 +0000, IANAL_VISTA interested us by writing:

> thomas.vandierendonck_at_gmail.com wrote in 
> news:1118750526.951724.48630_at_g43g2000cwa.googlegroups.com:
> 

>> Hi,
>>
>> I'm having a bit of a problem here. I'm developing a web service client
>> that should be integrated in pl sql stored procedures.
>> For certain reasons I want to run the java part on the application
>> server (because this server has direct access to the internet and the
>> DB-server doesn't).
>> Does anybody have any idea how I can call the java classes from within
>> the pl sql stored procedures WITHOUT loading any java in the database?
>>

> USER<-->BROWSER<-->APACHE<-->APP_SERVER<-->ORACLE
> IMO, the code running in/on the APP_SERVER invokes PL/SQL; not vice
> versa.

If OP is using Oracle Application Server (9i or 10g) then another way is to go

USER<-->BROWSER<-->APACHE + mod_plsql<-->ORACLE

and the Java app can issue HTTP requests to the Apache. This can create visually complex situations such as

USER<-->BROWSER<-->APACHE<-->APP_SERVER<-->APACHE + mod_plsql<-->ORACLE

Other possibilities include (heaven forbid) reading the documentation at http://docs.oracle.com, specifically in the database section (either 9i or 10g) and looking for the 'JDBC Developer's Guide and Reference'. Amusingly, or perhaps boringly, chapter 3 has a section titled

   Stored Procedure Calls in JDBC Programs

        PL/SQL Stored Procedures
        Java Stored Procedures

with examples of actual code.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Tue Jun 14 2005 - 10:20:47 CDT