Re: oracle 8i database trigger - showing error message on a visual basic form

From: <>
Date: Thu, 27 Apr 2017 02:55:56 -0700 (PDT)
Message-ID: <>

[Quoted] On Wednesday, 16 May 2001 02:15:14 UTC+7, Jeanette Weldon wrote:
> what I need to do is show an error message on a visual basic form and force
> the user to enter a specific field if it is null in certain cases when the
> user commits the record. I cannot make the column mandatory as it must only
> be populated in certain cases. The user is using a visual basic form on an
> oracle 8i database. I do not have access to the visual basic form source
> code so I thought I'd try and write an oracle database trigger.
> below is my database trigger but I get a run-time
> error against the RAISE_APPLICATION_ERROR line.
> CREATE OR REPLACE TRIGGER sdc_moa_db_trigger
> BEFORE INSERT OR UPDATE OF ae_mode_of attendance
> ON application_events
> FOR EACH ROW WHEN (new.ae_mode_of_attendance
> AND new.ae_evt_ref_no != '100')
> RAISE_APPLICATION_ERROR(-20000,<message>);
> END;
> Jeanette
Received on Thu Apr 27 2017 - 11:55:56 CEST

Original text of this message