Re: PLS-00225: subprogram or cursor 'LOG' reference is out of scope

In article <6e366956.0110240633.725c73d3_at_posting.google.com>, thomas.hiller_at_warema.de says...
>
>Hello
>
>I want to create a trigger which logs changes made to a table. The
>changes should be written to a table with the same name in another
>schema. I tryed the following statement:
>
>CREATE OR REPLACE TRIGGER test
> BEFORE DELETE ON ndl.OA_WA
>FOR EACH ROW
>DECLARE
>
>....
>
>BEGIN
>
> insert into log.oa_wa values (...);
>
> EXCEPTION
>...
>
>END
>
>After Compiling I always get the error-message "PLS-00225: subprogram
>or cursor 'LOG' reference is out of scope"
>
>What's the reason for that Problem. I have no idea.
>
>Could anyone help me??
>
>regards
>thomas

see
http://osi.oracle.com/~tkyte/Misc/RolesAndProcedures.html

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp