PROMPT and REM at SQL Window

[ed10k]

Is it possible to treat sqlplus commans PROMPT and REM/rem at SQL Window?

Command Window does that (and highlights this properly).

My problem: I want to execute a sqlplus Script at SQL Window step by step with F8 ("AutoSelect statement is checked"). If this script have PROMPTs or REMs then i get "ORA-00900: invalid SQL statement"

 

[SunDog]

I second that!

 

[Marco Kalter]

Note that the Command Window can also run your scripts step by step by using the Pause button.

 

[ed10k]

The requested feature would make sense nevertheless.

 

[braykov]

Also SQL*Plus commands should be properly beautified, e.g. capitalized.

On Marco's point:
I personally don't want to run it step by step. I edit automatic SQL scripts in the SQL window. They mostly include an INSERT -> COMMIT -> UPDATE -> COMMIT and those kind of commands (with certain PROMPTs in between), so I really use PLD to run the inserts and updates and then do a rollback while editing the scripts.

 

[braykov]

And also any text after PROMPT should not be beautified. Check this out:

PROMPT Please WAIT WHILE UPDATE names FOR PRIMARY customers...;

Deleting and retyping won't help. It's automatically capitalized. :-(