Any advice welcome:
I'm getting this error from a packaged procedure called from a
before create on schema trigger, but the procedure itself is not doing any DDL - and I don't always get the error :-(.
The error occurs at a line where it does an insert:-
insert into expired_source_detail
(es_detail_ref, line, text)
select <local_variable>, line, text
from all_source
where owner = USER
and name = <procedure_parameter_one>
and type = <procedure_parameter_two>;
I can't see how the DDL that isn't there can be invalid !!
The error does not occur consistently. It does mean that I can't rebuild some packages on occasion unless I disable the trigger or add a 'when others then null;' after this command. I would like to find the cause, though. From what my research shows, the errors is normally returned when triggers are attempting DDL ! Could there be some implicit DDL? (He asks speculatively)
RDBMS 10.2.0.4.0 on Linux x86-64
Thanks,
Tim