Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger & Sequence
Mark C. Stock wrote:
> daniel's suggestion is good, except SQL*Plus has it's own little quirk in
> that SHOW ERRORS does not work on trigger compilation errors
> to follow his advice and see the errors, you'll need to do a SELECT from the
> USER_ERRORS data dictionary view
Excuse me ...
SQL> CREATE TABLE orders (
2 somecolumn VARCHAR2(20),
3 numbercol NUMBER(10),
4 datecol DATE);
Table created.
SQL> CREATE OR REPLACE TRIGGER statement_level
2 BEFORE UPDATE
3 ON orders
4
5 DECLARE
6 vMsg VARCHAR2(30) := 'Statement Level Trigger Fired';
7 BEGIN
8 dbms_output.put_linZe(vMsg);
9 END statement_level;
10 /
Warning: Trigger created with compilation errors.
SQL> sho err
Errors for TRIGGER STATEMENT_LEVEL:
LINE/COL ERROR
-------- --------------------------------------------------- 4/3 PL/SQL: Statement ignored 4/15 PLS-00302: component 'PUT_LINZE' must be declaredSQL> It doesn't? Now you tell me. ;-)
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Tue Feb 14 2006 - 12:42:08 CST