Re: Database Triggers

You can use database alerters mechanism set up and handled through DBMS_ALERT database PL/SQL package with any Oracle 7.3.x and Oracle 8.x version as the following:

Java application w/alerter handling + JDBC + database trigger w/alerter setup

or

VB application w/alerter handling + ODBC + database trigger w/alerter setup

You can use both java or PL/SQL to create the database triggers with Oracle8i and only PL/SQL with older version of Oracle. See the Oracle Application Developer's Guide for directions on using DBMS_ALERT database PL/SQL package.

Good luck,
Eugene.

Seetharaman Shrinivasan <borntocode_at_hotmail.com> wrote in message news:0764c19a.6757b250_at_usw-ex0108-062.remarq.com...
> I want to execute an Java app or VB app after any
> modification in a table or row of a table. How to do
> that? Pls. help me out in this regard. How to design the
> client app. to this server trigger?
>
> Thanxs to all enthusiastic repliers
>
> Seetharaman
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful Received on Mon Jan 24 2000 - 19:16:27 CET