Hi,
Is there a way I can execute a script/ sql from SQL Developer to be run in SqlCl? I am trying to do without having to explicitly open SqlCl , connect to a database and run the script. I am hoping that SqlCl will connect to the database I am connected to in the current worksheet.
The IDE I was using before Sql Developer had 2 options like this. I could "execute script in script runner" or "execute in sqlplus". This would open a new instance of script runner (or sqlplus) connect to the database and start running the script.
I know that Sql Developer has an Unshared worksheet option which should be similar to this. It does not work in my case because my instance of Sql Developer becomes unusable. See thread. Every time I have a long running task, I have to open a new instance.
Version: 19.4
Thanks!