Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger & Sequence

Re: Trigger & Sequence

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 14 Feb 2006 10:42:08 -0800
Message-ID: <1139942523.850946@jetspin.drizzle.com>


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 declared
SQL> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US