Create trigger with sqlplus pl/sql block (called from a windows bat script) generates an exception o
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:
0