Re: Oracle triggers and procedures creation diagnostic

From: elk <Andy_at_entasuru.demon.co.uk>
Date: Thu, 3 Sep 1998 00:28:13 +0100
Message-ID: <904778514.669.0.nnrp-06.9e982820_at_news.demon.co.uk>


After getting the compilation errors message try typing: show errors
at the command prompt.
If this doesn't give you any more info try selecting from user_errors table. Valentine Pogrebinsky wrote in message
<6siqev$j5l$1_at_hyppo.anet.donetsk.ua>...
>Which primary tool I can to use for creation and debugging of trigger &
>procedures?
>SQL*Plus generates messages like
>
>MGR-00072: Warning: TRIGGER ADD_TO_BALANCE created with compilation errors.
>
>without any pointers to operators or strings with error.
>What can I do?
>
>Valentine Pogrebinsky
>
>
Received on Thu Sep 03 1998 - 01:28:13 CEST

Original text of this message