Copy and paste data from the previous statement raises" object not found " message within the SQL editor.
Example:
Select * from tableA
where id = ' XXXX '
Select * from tableB
where id = copy and paste ' XXX' - from last statement raises object not found messages.
When you Copy | Paste into ' XXXX ' while holding the ctrl key. You will receive this message: " Object ' XXXX ' Not found ". If the Ctrl key is being held while you click within the single quotation marks Toad will request for the detail of the table. The reason for the error message displayed is because it is not a valid table.
WORKAROUND 1:
When you copy and paste, make sure the ctrl key is not being held after you copy. In other words
- Highlight the data you want to copy, (ctrl+C)
- Remove your finger from the Ctrl key.
- Click where you want to paste
- Now proceed to paste (ctrl+V).
WORKAROUND 2:
- highlight the entire data (include parenthesis) when you copy and when you paste.
When you Copy | Paste into ' XXXX ' while holding the ctrl key. You will receive this message: " Object ' XXXX ' Not found ". If the ctrl key is being held while you click within the single quotation marks Toad will request for the detail of the table. The reason for the error message displayed is because it is not a valid table.
