Re: tool

@Ste wrote:
> Hello NG
> I'm looking for an oracle tool (or an external tool) able to call
> external procedures when someone modify a record in a table.
> The problem is that a program (not developed by me) makes changes in a
> table and I need to update a second database (and make other non db
> tasks) immediately after the record is written.
> Is this thing possible ?
>
> thanks in advance,
>
> @Ste

If version 10g look at the dbms_change_notification built-in package. demo in Morgan's Library at www.psoug.org

If an earlier version then likely you will need to look at using an AFTER INSERT OR UPDATE OR DELETE trigger again there are demos in the library under "table triggers"

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org