ora-24344 means there was a compilation error .... perhaps you should check the code ... that might work.
Raj
triggers, stored procedures, etc. The programmer involved has contacted me because they have to do this via a stored procedure. The reason is that the tool they are using (Synopsis) isn't easily able to call O/S scripts. The problem they are having is in creating the triggers. The triggers get created (via an "execute immediate" statement), but are invalid and the stored procedure returns an error (ora-24344 success with compilation error).
