Re: architecture issue

> The only way I know about is to create a package with java functions
> that can establish a connection, pass data and close the connection at
> the end. Is it possible to keep a 'session' when using functions
> from a package?

You can do this in Java should you choose. Have you looked at the supplied UTL_TCP package to see if it meets your needs?

Additionally, it sounds like what you are building could benefit from Advanced Queueing (AQ). Your trigger can place a message for your server in the queue and then the server comes by and consumes those messages. I'm not sure if it fits the bill for you or not, but you might want to look into it.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown