Explain Plan Window bug

[ed10k]

In the middle of a package I select the following:

SELECT (SELECT COUNT(*) FROM USER_TAB_COLUMNS t WHERE t.TABLE_NAME = 'HIS_OMS_MESSAGE_ADMIN')
       - (SELECT COUNT(*) FROM USER_TAB_COLUMNS t WHERE t.TABLE_NAME = 'HIS_OMS_MESSAGE_ADMIN_N') COL_DIFF
  INTO l_col_diff
  FROM DUAL
  ;

and then F5. The Explain Plan Window appears with a error: ORA-00936: missing expression.
The "INTO l_col_diff" is commented badly.

 

[Marco Kalter]

This is indeed not quite right. We'll fix it.

 

[Jupi]

explain window bug:
ver 7.1.
Filter predicates and access predicates value is always empty.