0

I have the following .bat file that calls 2 sql scripts.

start C:\sqlcl-latest\sqlcl\bin\sql javi/pwd@tnsname @"mypath1"
start C:\sqlcl-latest\sqlcl\bin\sql javi/pwd@tnsname @"mypath2"

However, when I execute this, the SQLCL windows that are opened in parallel are not closed when the execution ends. What can I add to close them off if no error is raised during the executions?

jarlh
  • 42,561
  • 8
  • 45
  • 63
Javi Torre
  • 724
  • 8
  • 23
  • 2
    SQL scripts should then end with an "exit" statement. – p3consulting Jan 18 '23 at 16:07
  • @p3consulting would there be any way to achieve the same result in the command line itself just to allow the script to be compatible with, let´s say SQL Developer? – Javi Torre Jan 19 '23 at 06:52
  • 1
    How to you imagine the .bat could reconnect to the same existing session? the only alternative would be to "pipe" the file then the "exit" command to the same sqlcl process instead of using the @ command. – p3consulting Jan 19 '23 at 10:02

0 Answers0