Hi all!
I have an SQLPLUS script. From that SQL-script I can call an external SQL like next: @sqlname.sql . It's work correctly.
My problem is the next: If I embed this external script into middle of my main SQL script, then I can't return from the external script to the main script. The rest part of the main script doesn't work. And is similar to problem, if I want to call an second or more external scripts from the main SQL script.
Example:
"select ..... ;
update .... ;
@sqlscript1.sql
-- From here does nothing the main script, it is lost for me
@sqlscript2.sql
select ... ;
rollback;"
Thanks forward!
I have an SQLPLUS script. From that SQL-script I can call an external SQL like next: @sqlname.sql . It's work correctly.
My problem is the next: If I embed this external script into middle of my main SQL script, then I can't return from the external script to the main script. The rest part of the main script doesn't work. And is similar to problem, if I want to call an second or more external scripts from the main SQL script.
Example:
"select ..... ;
update .... ;
@sqlscript1.sql
-- From here does nothing the main script, it is lost for me
@sqlscript2.sql
select ... ;
rollback;"
Thanks forward!