When displaying the results of 'v$sql_bind_capture' an Access Violation error will occur while scrolling to the right edge of the result set:
1. Open a SQL Editor in Toad
2. Type in: select * from v$sql_bind_capture;
3. In the third column choose a valid sql_id and copy it into the clipboard
4. Run the statement "select * from v$sql_bind_capture where sql_id=:SQL_ID;" and enter the copied value from the clipboard into the dialogue.
5. Click into the result set and scroll the cursor to the right border
Toad crashes.
This happens when you try to display the ANYDATA column.
WORKAROUND 1:
As displaying the ANYDATA type column in this view is causing the problem, either specify the columns in the select statement, but don't include the one that is ANYDATA.
WORKAROUND 2:
Only look at this view in the Schema browser, if you do so, Toad will automatically exclude the ANYDATA column.
STATUS:
Waiting for a fix to be released in a future version of Toad for Oracle.
