can I use Oracle trigger to execute other program?

[xiongye_2]

Hi: all, Can I execute other program(Tuxedo or java ) in Oracle trigger ? Thanks !!!

[Steven Gillard_2]

As of Oracle 8i its possible to write stored procedures (including triggers) in java. The following is the java stored procedure development guide:

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/java.817/a81358/toc.htm

Regards,
Steve

[Tom Geudens · Accepted solution]

Hi,
Yes you can ...
Take a look at the following thread (where I answered a similar question :-) :
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xcac1a2db8513d6118ff40090279cd0f9,00.html

Regards,
Tom Geudens

[Ryan Kogelheide]

Tom's answer is correct, but the way we did it before external proc calls was to write our own "listener" in an external process that connects to the database and listens on a DBMS_PIPE.

Other stored procedures or triggers can then send to the DBMS_PIPE.

There is an example of the listener in C in the Supplied PL/SQL Packages Reference under DBMS_PIPE examples.

If you're concerned about the security problems that Tom mentioned (I've never looked...) then consider the DBMS_PIPE solution.

Also, if you want to do something simple like send a mail or a simple TCP call, there are the supplied PL/SQL packages UTL_SMTP and UTL_TCP that work if you have the JServer component installed.

Good luck.

Ryan