Re: Trigger & Sequence ++ show errors for triggers

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1139942523.850946_at_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)

Not without a database version and OS!

ok, i've had problems with this in the past, and tested it on 10.1.0.2.0 before i posted, and it appeared not to work

tried your example, and it worked

didn't save my test

so, we know it works in 10.1.0.2.0 and whatever version you're running but refused to disclose ;-)

i do recall having issues with this in the past, though. anyone else remember any problems with this?

++ mcs Received on Tue Feb 14 2006 - 12:59:34 CST