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

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 15 Jun 2005 01:58:47 GMT
Message-ID: <Xns9675C1133BD9ESunnySD@68.6.19.6>

HansF <News.Hans_at_telus.net> wrote in
news:pan.2005.06.14.15.23.45.320489_at_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
>

Alternatively use DBMS_HTML from inside Pl/SQL to invoke a JSP. Received on Tue Jun 14 2005 - 20:58:47 CDT