|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > triggers...need help!!! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|