topic Re: can I use Oracle trigger to execute other program? in Operating System - HP-UX

can I use Oracle trigger to execute other program?

xiongye_2 — Wed, 27 Mar 2002 09:41:17 GMT

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

Re: can I use Oracle trigger to execute other program?

Steven Gillard_2 — Wed, 27 Mar 2002 09:56:47 GMT

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

Re: can I use Oracle trigger to execute other program?

Tom Geudens — Wed, 27 Mar 2002 10:16:31 GMT

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

Re: can I use Oracle trigger to execute other program?

Ryan Kogelheide — Wed, 27 Mar 2002 13:32:56 GMT

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