architecture issue

Hi,

I'm having a problem of architecture nature and due to time constraints and having little knowledge about Oracle I need your help. Thanks for any suggestions.

Basically I need to develop an app that runs on windows platform and it's responsible for triggers management on oracle. So when required it'd create, modify and delete triggers. From what I've read the OCI would be an ideal choice, I could remotely connect to Oracle and give it specific commands. Am I right? What do you think? What sort of privileges does user need to manage triggers?

There's a next part. All triggers created on Oracle by my app have to notify my server running on a remote machine when fired. I also would like to pass data to the server e.g. for delete triggers row(s) that have been deleted. I imagine process for e.g. delete trigger might look like the following:

Trigger body
{

   Open up a connection to the server

   For each row deleted
pass data to the server

   Close the connection
}

I'd like to connect to the server using TCP/IP from within a trigger.

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?

Maybe there is a better technology to use. What do you think?

Please help thanks

Best regards,
schw Received on Mon Apr 24 2006 - 04:48:47 CDT