Hi,
I have a trigger DDL, when I try to run the DDL, I got the compilation
error.
But I use 'show error' command, I got 'no error' .
is there any configuration I need to set to enable 'show error '
function?
By the way, I could see the error in dba_errors ...
any suggestion is very appreciated.
Thanks.
On May 10, 1:55 pm, esthershe
@yahoo.com wrote:
> Hi,
> I have a trigger DDL, when I try to run the DDL, I got the compilation
> error.
> But I use 'show error' command, I got 'no error' .
> is there any configuration I need to set to enable 'show error '
> function?
> By the way, I could see the error in dba_errors ...
> any suggestion is very appreciated.
> Thanks.
Immediately after the error is displayed and compilation is terminated
execute "show errors" and, in almost all cases, you will see the
associated error. Please show us exactly what you did and what Oracle
reported. It will be much easier to answer your question if you do.
David Fitzjarrell
-----------------------------------------------Reply-----------------------------------------------
<esthershe@yahoo.com> a crit dans le message de news: 1178823315.943224.200@y5g2000hsa.googlegroups.com...
| Hi,
|
| I have a trigger DDL, when I try to run the DDL, I got the compilation
| error.
|
| But I use 'show error' command, I got 'no error' .
|
| is there any configuration I need to set to enable 'show error '
| function?
|
| By the way, I could see the error in dba_errors ...
|
| any suggestion is very appreciated.
|
| Thanks.
|
show errors trigger my_trigger
Regards
Michel Cadot
-----------------------------------------------Reply-----------------------------------------------
On Thu, 10 May 2007 11:55:16 -0700, esthershensh wrote:
> I have a trigger DDL, when I try to run the DDL, I got the compilation
> error.
It's an oracle bug. Report it to oracle. Oracle shouldn't be checking
syntax, it's an extremely rude thing to do.
--
http://www.mladen-gogala.com
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc
