Sabutmaster wrote:That works for me. Post a complete test case (say 0.sql, 1.sql and 2.sql) that people can run to re-create the problem and test their ideas.
I have many .sql files, that i want to be launched one by one.
The fist one is 0.sql file:
When I launch it:
It execute @1.sql and all statements in that file completes successfull, and then I See again SQL>
3 Month ago, I used that structure for scripts and all was OK, all one by one was launched, but now, only first launched and ends.
I'm using Oracle 8i as on client on my side, but Server is Oracle 10g version.You should install SQL*Plus version 10. Some features (like WITH clauses) won't work with the older client.
Please tell me, how to create correct sql file, to execute many or multiple sql scripts.What you posted should work.