Say I have a SQL*Plus scripts that I want to run step by step in PL/SQL Developer's SQL window:
insert into table ....;
@package/body/some_package.sql
/* some long comment
...
*/
insert into table ....;
First insert is fine.
I can't run the @-statement itself, which is slightly annoying, but I can live with that.
It would be amazing if it could run it though (with current directory set to either the current file's directory, or the predefined Files location I opened it from)
When I put the cursor in the second insert and run it, the AutoSelect will scan backwards and include both the comment and the @-statement, and give me an "ORA-00900 invalid statement" error.
Instead I have to select that statement before executing it.
It would be nice if the scanner understood that the "@" was a separate statement and stopped there.
It would be even nicer if it then scanned forwards, past the comment, and only selected the actual statement.