Oracle Trigger

From: Theran Crooks <crooks_at_globeset.com>
Date: Mon, 18 Oct 1999 17:21:04 -0500
Message-ID: <7ug6pn$ohh$1@onion.globeset.com>

I am attempting to create a trigger in Oracle that will update the value of one of the rows in the
table if it is modified by a start-up application.

CREATE OR REPLACE TRIGGER "CADBUSR"."SETURL"     AFTER UPDATE ON "CADBUSR"."CFGDB"
  BEGIN

     UPDATE CFGDB
            SET VALUE = 'http://machine:port/'
            WHERE KEY4 = 'CA_Set_Url' AND VALUE != 'http://machine:port/';

  END; This places the system in a loop until the max # of cursors is exceeded. I would appreciate
any advise on how to implement this.

Thanks,

Theran Crooks Received on Mon Oct 18 1999 - 17:21:04 CDT