Re: Trigger & Sequence ++ show errors for triggers

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 14 Feb 2006 15:11:23 -0500
Message-ID: <Cq-dnYvCH9TxpG_eRVn-ow@comcast.com>

"Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message news:dstbbd$tr2$1_at_news4.zwoll1.ov.home.nl...
: Mark C. Stock wrote:
: > 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?
: >
:
: You mean when you had compilation errors, and
: show error told you "no errors"?
: About every version, including 10g Release 1.
: : All it takes are multiple program units to compile
: with errors. Oracle simply does not understand which
: one to choose and you *must* specify the program unit
:
: show error package blah
:
: --
: Regards,
: Frank van Bortel
:
: Top-posting is one way to shut me up...

nope, that's not it.... but some variation of that does sound familiar

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Feb 14 15:08

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - P With the Partitioning, OLAP and Data Mining options

SQL> create procedure bad1
  2 as
  3 begin
  4 badbad;
  5 end;
  6 /

Warning: Procedure created with compilation errors.

SQL> show error
Errors for PROCEDURE BAD1:

LINE/COL ERROR

-------- ----------------------------------------------------
4/4      PL/SQL: Statement ignored
4/4      PLS-00201: identifier 'BADBAD' must be declared

SQL> create procedure bad2
  2 as
  3 begin
  4 badbad;
  5 end;
  6 /

Warning: Procedure created with compilation errors.

SQL> show error
Errors for PROCEDURE BAD2:

LINE/COL ERROR

-------- ----------------------------------------------------
4/4      PL/SQL: Statement ignored
4/4      PLS-00201: identifier 'BADBAD' must be declared

SQL> create trigger bad3 before insert on emp   2 for each row
  3 begin
  4 badbad;
  5 end;
  6 /

Warning: Trigger created with compilation errors.

SQL> show error
Errors for TRIGGER BAD3:

LINE/COL ERROR

-------- ----------------------------------------------------
2/3      PL/SQL: Statement ignored
2/3      PLS-00201: identifier 'BADBAD' must be declared

Received on Tue Feb 14 2006 - 14:11:23 CST