PL/SQL (MOSC)

MOSC Banner

Create trigger with sqlplus pl/sql block (called from a windows bat script) generates an exception o

edited Nov 6, 2009 4:13AM in PL/SQL (MOSC) 13 commentsAnswered
  Hi I have a windows bat file(a.bat) which calls sqlplus with a pl/sql block defined in a file (b.sql). This file updates a db with some objects. Among them are some triggers. When I execute the a.bat script I get the following error message: Start my script. 1 2 Something IS wrong! Error code: -24344 Error message: ORA-24344: success with compilation error -------------------------- There is an exception on the first create trigger ..attempt. What is wrong with the script? How do I get it to work? --------------------------- Here is an extract from the files: a.bat content:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center