4 Replies - 347 Views - Last Post: 28 November 2018 - 10:20 AM Rate Topic: -----

#1 11ash1   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 39
  • Joined: 25-October 15

SQL Warning error for trigger

Posted 27 November 2018 - 03:00 PM

Hello, I am currently working on triggers and I have a trigger i am not sure what the problem is. I was wondering if someone could help me figure out what is wrong. Thank you. I appreciate it.

1.Trigger to raise error on new purchase or updated purchase

CREATE OR REPLACE TRIGGER reminder1
AFTER INSERT OR UPDATE ON PurchasedDeal
FOR EACH ROW
BEGIN
RAISE_APPLICATION_ERROR( 'Notify new Purchased Deal Created or updated' );

END;


Is This A Good Question/Topic? 0
  • +

Replies To: SQL Warning error for trigger

#2 astonecipher   User is offline

  • Senior Systems Engineer
  • member icon

Reputation: 2915
  • View blog
  • Posts: 11,331
  • Joined: 03-December 12

Re: SQL Warning error for trigger

Posted 27 November 2018 - 03:02 PM

And the issue is?
Was This Post Helpful? 0
  • +
  • -

#3 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15215
  • View blog
  • Posts: 60,898
  • Joined: 12-June 08

Re: SQL Warning error for trigger

Posted 27 November 2018 - 03:02 PM

Please explain what is not working right.
Was This Post Helpful? 0
  • +
  • -

#4 11ash1   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 39
  • Joined: 25-October 15

Re: SQL Warning error for trigger

Posted 27 November 2018 - 03:41 PM

View Postastonecipher, on 27 November 2018 - 03:02 PM, said:

And the issue is?

Sorry. For some reason it only said
Warning: Trigger created with compilation errors.
Was This Post Helpful? 0
  • +
  • -

#5 astonecipher   User is offline

  • Senior Systems Engineer
  • member icon

Reputation: 2915
  • View blog
  • Posts: 11,331
  • Joined: 03-December 12

Re: SQL Warning error for trigger

Posted 28 November 2018 - 10:20 AM

So, why would you be throwing an error if that table is touched?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1