Home » RDBMS Server » Server Administration » trigger with warning message
trigger with warning message [message #370484] Thu, 02 December 1999 22:19 Go to next message
Ooiewe
Messages: 3
Registered: December 1999
Junior Member
Hi,

How do i make sure that a trigger is working before fire that particular trigger?

FYI, the trigger is created with compilation error, but i wouldn't know this as the trigger is created from a C++Builder app. The trigger will still be created although there is compilation error.

Thanks in advance
Re: trigger with warning message [message #370493 is a reply to message #370484] Mon, 06 December 1999 06:49 Go to previous messageGo to next message
hmg
Messages: 40
Registered: March 1999
Member
Hi,

try this statement

select status from user_triggers
where trigger_name = 'YOURTRIGGER';

status could be ENABLED (valid) or DISABLED (invalid).

Bye
Re: trigger with warning message [message #370499 is a reply to message #370493] Tue, 07 December 1999 03:24 Go to previous message
Ooiewe
Messages: 3
Registered: December 1999
Junior Member
Warning: Trigger created with compilation errors.

SQL> SHOW ERRORS
Errors for TRIGGER ASM_RETURN_INSERT:

LINE/COL ERROR
--------------------------------------------------
2/1 PL/SQL: SQL Statement ignored
5/8 PLS-00395: wrong number of values in VALUES clause of INSERT
statement

SQL> select status from user_triggers
2 where trigger_name = 'ASM_RETURN_INSERT';

STATUS
--------
ENABLED

Hi,

The trigger is not working, but the STATUS is enabled. What should i do to make sure that any existing trigger is working (successfully compiled without error), as STATUS of the trigger doesn't seems useful to me?

Thanks again
Ooiewe
Previous Topic: I need an PL/SQL algorithm to hand combination searching
Next Topic: I need an PL/SQL algorithm to handle combination searching
Goto Forum:
  


Current Time: Wed Oct 28 07:23:06 CDT 2020