We need an oracle trigger or java stored procedure to be able to call
a java application outside of the oracle jvm. Can this be done?

From sun website, looks like JSP can only call java program inside
oracle jvm. They also list a way around this, by using appserver and
webservices approach.

Anything else?

thanks.

c

chris wrote:
> We need an oracle trigger or java stored procedure to be able to call
> a java application outside of the oracle jvm. Can this be done?
>
> From sun website, looks like JSP can only call java program inside
> oracle jvm. They also list a way around this, by using appserver and
> webservices approach.
>
> Anything else?

Well, presumably you're trying to avoid starting a new VM for this "java
application" or you'd just use Runtime.exec(). The only way I can think
of avoiding that is to have something that looks like a service running.
It's not particularly difficult to roll your own simple SOAP
substitute using UTL_TCP and a Java daemon.

--
Richard Kuhler

Am Tue, 09 Nov 2004 22:47:05 GMT schrieb Richard Kuhler
<noone@nowhere.com>:

> chris wrote:
>> We need an oracle trigger or java stored procedure to be able to call
>> a java application outside of the oracle jvm. Can this be done?
>>
>> From sun website, looks like JSP can only call java program inside
>> oracle jvm. They also list a way around this, by using appserver and
>> webservices approach.
>>
>> Anything else?

You may call the java application from an external library (.dll or .so).
See "External Routines" in "Application Developer’s Guide - Fundamentals"
from the Oracle Documentation.

--
Frank Piron,
etfrankatkonaddotn
(leftrotate two)

On Wed, 10 Nov 2004 05:40:11 +0800, chris wrote
(in article <c452700a.0411091340.609edd3c@posting.google.com>) :

> We need an oracle trigger or java stored procedure to be able to call
> a java application outside of the oracle jvm. Can this be done?
>
> From sun website, looks like JSP can only call java program inside
> oracle jvm. They also list a way around this, by using appserver and
> webservices approach.
>
> Anything else?
>
> thanks.
>
> c

you can call it using normal java calls.
just supply the classpath.
or if you want to get clever , you can compile it from within the , using the
java compiler outside the vm, then call it.