Return
-
Title
The EDIT command is not working over multiple lines -
Description
If I run an Edit command in the Toad editor that is written in multiple lines, the Editor only seems to read the first line only. See the example below.
Scenario A:edit table_name where col1=123 or
col1=333Causes Error: ORA-00921: unexpected end of SQL command
Scenario B:edit table_name
where col1=123 or col1=333Will only run the first line of "Edit table_name" and ignores the WHERE criteria
Scenario C:edit table_name where col1=123 or col1=333Will run the entire statement as excpected. -
Resolution
WORKAROUND:
None.
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle. -
Defect ID
ST78624