Ctrl + Enter keys don't execute correctly when comments are present. No data is returned on th (4274268)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Ctrl + Enter keys don't execute correctly when comments are present. No data is returned on th
Description

In SQL Editor, using the Ctrl+Enter keys to execute SQL statements does not return data correctly on the datagrid, when there are comments immediately above the SQL statements.
However, everything works fine when using execute/compile button.

To reproduce see below:

/*
* test_comment
*/
select
dummy
from dual
where 1=:value
;

(enter the value 1 for variable named value)
Resolution

WORKAROUND:
1. Add a new line between comments (in /* ... */ format), and the SQL statements.
2. Execute using the execute/compile button
STATUS:
Waiting for fix in a future release of Toad for Oracle
Defect ID

ST79921

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title