This content has been marked as final. Show 1 reply
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.
If you're still using database version 8, then you'll need to keep SQL*Plus 8 as well. You can have multiple versions of SQL*Plus on the same machine.
This probably has nothing to do with your current problem.
Please tell me, how to create correct sql file, to execute many or multiple sql scripts.What you posted should work.