Re: Calling O/S Scripts From PL/SQL

ora-24344 means there was a compilation error .... perhaps you should check the code ... that might work.

Raj

   We have an issue where we need to drop and recreate tables, indexes,
> 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).
>

--
http://www.freelists.org/webpage/oracle-l