Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Calling O/S Scripts From PL/SQL

Re: Calling O/S Scripts From PL/SQL

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 17 Aug 2006 07:36:06 -0400
Message-ID: <9177895d0608170436h12d68be0nab5bd7c5d0b033e8@mail.gmail.com>


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
Received on Thu Aug 17 2006 - 06:36:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US