SQL worksheet F9 problem
481013Jan 17 2006 — edited Jun 29 2006Try this, paste the following lines into the SQL statement area
select 8
select count(*) from user_tables;
position the cursor on the count(*) line, press F9. the command at the cursor should be executed, but it is not. and ora-00923 error is returned.
the problem is that the parsing is starting at the first line in the window. it will work if the first line is commented out. the proper way to handle this is to find the command associated with the cursor, and just parse (and execute) that command. that is the difference between run script and execute statement.