#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    4
    Rep Power
    0

    Unhappy triggers...need help!!!


    CREATE OR REPLACE TRIGGER validtable
    BEFORE INSERT ON playerTables
    FOR EACH ROW
    BEGIN
    IF (:new.tableNum < 10)
    THEN RAISE_APPLICATION_ERROR(-20000, 'my error message');
    END IF;
    END;


    ----------------------------------------------------------
    are these 3 lines supposed to print out or just my error message(ORA-20000)?

    ORA-20000: my error message
    ORA-06512: at "51723545.VALIDTABLE", line 3
    ORA-04088: error during execution of trigger '51723545.VALIDTABLE'
  2. #2
  3. No Profile Picture
    almost there....
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    A Red Glitter Coffin
    Posts
    140
    Rep Power
    0
    ya they're supposed to be, you my be able to get rid of them? but i don't know. If you're accessing your database thru java you can just catch the errors

IMN logo majestic logo threadwatch logo seochat tools logo