clear screen from sql file
at sqlplus prompt, I can type either HOST CLS or CLEAR SCREEN and both work..
but when I put either of them in an .sql file and run it from sql with @c:\file.sql
both commands error with:
ORA-06550
PLS-00103 encountered 'CLS' or 'SCREEN'
OS IS Windows 7 with Oracle 11.1.0.6 client
my goal is to run a dbms_output line while in a loop
so the data shows on the screen and refreshes when it is changed
without clearing the screen, it just shows over and over and scrolls by a list of them very fast