Toad World® Forums

NO DATA FOUND on typing a left round brace


#1

Hi

I am a relatively new user of Toad @ my workplace and currently using 11.6.1.6.

Whenever I type in a left round brace after an in clause, Toad gets busy in the background and then throws an error :

ORA-00942: table or view does not exist

For e.g. SELECT * FROM MYTABLE WHERE VAL IN ( …

After clicking ok, toad throws an acces violation

Access violation at address 010A3966 in module ‘Toad.exe’. Read of address 000000AC

Is someone else also facing this issue?


#2

Hi,

When you click that open parenthesis, Toad starts looking for parameters to give you a hint as to which parameters are available. You can see the query that
runs if you open Database > Monitor > SQL Tracker. Check “Toad” and then type your open parenthesis again. This should at least help you diagnose the problem.

In the meantime you can turn off the parameters lookup in options > Editor > Code assist: Enable parameter assistance.

Thanks,

Brad

From: shubham.garg [mailto:bounce-shubhamgarg@toadworld.com]

Sent: Friday, July 05, 2013 1:17 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] NO DATA FOUND on typing a left round brace

NO DATA FOUND on typing a left round brace

Thread created by shubham.garg

Hi

I am a relatively new user of Toad @ my workplace and currently using 11.6.1.6.

Whenever I type in a left round brace after an in clause, Toad gets busy in the background and then throws an error :

ORA-00942: table or view does not exist

For e.g. SELECT * FROM MYTABLE WHERE VAL IN ( …

After clicking ok, toad throws an acces violation

Access violation at address 010A3966 in module ‘Toad.exe’. Read of address 000000AC

Is someone else also facing this issue?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#3

Also send the error report if one was generated. When you get the AV the dialog should have a link to view the full report. The call stack is what we’ll need.
Thanks,
Michael


From: Brad Boddicker [bounce-ButtonPusher@toadworld.com]
Sent: Monday, July 08, 2013 10:40 AM
To: toadoracle@toadworld.com
Subject: RE: [Toad for Oracle - Discussion Forum] NO DATA FOUND on typing a left round brace
RE: NO DATA FOUND on typing a left round brace
Reply by Brad Boddicker
Hi,
When you click that open parenthesis, Toad starts looking for parameters to give you a hint as to which parameters are available. You can see the query that runs if you open Database > Monitor > SQL Tracker. Check “Toad” and then type your open parenthesis again. This should at least help you diagnose the problem.
In the meantime you can turn off the parameters lookup in options > Editor > Code assist: Enable parameter assistance.
Thanks,
Brad
From: shubham.garg [mailto:bounce-shubhamgarg@toadworld.com]
Sent: Friday, July 05, 2013 1:17 AM
To: toadoracle@toadworld.com
Subject: [Toad for Oracle - Discussion Forum] NO DATA FOUND on typing a left round brace
NO DATA FOUND on typing a left round brace
Thread created by shubham.garg
Hi
I am a relatively new user of Toad @ my workplace and currently using 11.6.1.6.
Whenever I type in a left round brace after an in clause, Toad gets busy in the background and then throws an error :
ORA-00942: table or view does not exist
For e.g. SELECT * FROM MYTABLE WHERE VAL IN ( …
After clicking ok, toad throws an acces violation
Access violation at address 010A3966 in module ‘Toad.exe’. Read of address 000000AC
Is someone else also facing this issue?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag this post as spam/abuse.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag this post as spam/abuse.


#4

Hi, the below query is running when I type in the brace:

Select TEXT

from SYS.ALL_SOURCE

where OWNER=‘SYS’

and NAME=‘STANDARD’

and TYPE=:type

order by LINE

I have checked with our DBA, and access to this view will not be granted, since its a SYS owned schema.

I have disabled parameter lookup and this is mitigated the issue.

Call Stack Information:


|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |


|*Exception Thread: ID=4188; Parent=0; Priority=-2 |

|Class=; Name=MAIN |

|DeadLock=0; Wait Chain= |

|Comment= |

|--------------------------------------------------------------------------------------------------------------------------------------------|

|7FFFFFFE|04 |00000000|010A3966|Toad.exe |00CA3966|tdEditorClasses |TCustomCreatePLSQLObject|FindIdentifier |2795[5] |

|00000040|04 |0675FC68|01CB7D59|Toad.exe |018B7D59|tdPLSQLResolver |TtdPLSQLResolver |ResolveExternalObject |467[64] |

|00000040|04 |0675FCC0|01CB7659|Toad.exe |018B7659|tdPLSQLResolver |TtdPLSQLResolver |Resolve |235[17] |

|00000040|04 |0675FD08|01CB7102|Toad.exe |018B7102|tdPLSQLResolver |TtdPLSQLResolver |ResolvePLSQLObject |164[4] |

|00000040|04 |0675FD28|02A40409|Toad.exe |02640409|tdParamCompletion|TToadParamCompletion |ExecuteAt |801[47] |

|00000040|04 |0675FD84|02A402B4|Toad.exe |026402B4|tdParamCompletion|TToadParamCompletion |DoTimer |724[4] |

|00000040|03 |0675FDB8|00483240|Toad.exe |00083240|System.Classes | |StdWndProc | |

|00000040|03 |0675FDD0|759162FA|USER32.dll|000162FA|USER32 | |(possible gapfnScSendMessage+818)| |

|00000040|03 |0675FDFC|75916D35|USER32.dll|00016D35|USER32 | |(possible GetThreadDesktop+210) | |

|00000040|03 |0675FE74|759177BF|USER32.dll|000177BF|USER32 | |(possible CharPrevW+307) | |

|00000040|03 |0675FED4|75917885|USER32.dll|00017885|USER32 | |DispatchMessageW | |

|00000040|03 |0675FEE4|006B5347|Toad.exe |002B5347|Vcl.Forms |TApplication |ProcessMessage | |



#5

Ø
I have checked with our DBA, and access to this view will not be granted, since its a SYS owned schema.

Your DBA’s reasoning is flawed. The ALL views are granted to public. They only show you objects that you have privileges on. The USER views are owned
by SYS too. Is he also taking them away?

From: shubham.garg [mailto:bounce-shubhamgarg@toadworld.com]

Sent: Monday, July 08, 2013 11:30 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] NO DATA FOUND on typing a left round brace

RE: NO DATA FOUND on typing a left round brace

Reply by shubham.garg

Hi, the below query is running when I type in the brace:

Select TEXT

from SYS.ALL_SOURCE

where OWNER=‘SYS’

and NAME=‘STANDARD’

and TYPE=:type

order by LINE

I have checked with our DBA, and access to this view will not be granted, since its a SYS owned schema.

I have disabled parameter lookup and this is mitigated the issue.

Call Stack Information:


|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |


|*Exception Thread: ID=4188; Parent=0; Priority=-2 |

|Class=; Name=MAIN |

|DeadLock=0; Wait Chain= |

|Comment= |

|--------------------------------------------------------------------------------------------------------------------------------------------|

|7FFFFFFE|04 |00000000|010A3966|Toad.exe |00CA3966|tdEditorClasses |TCustomCreatePLSQLObject|FindIdentifier |2795[5] |

|00000040|04 |0675FC68|01CB7D59|Toad.exe |018B7D59|tdPLSQLResolver |TtdPLSQLResolver |ResolveExternalObject |467[64] |

|00000040|04 |0675FCC0|01CB7659|Toad.exe |018B7659|tdPLSQLResolver |TtdPLSQLResolver |Resolve |235[17] |

|00000040|04 |0675FD08|01CB7102|Toad.exe |018B7102|tdPLSQLResolver |TtdPLSQLResolver |ResolvePLSQLObject |164[4] |

|00000040|04 |0675FD28|02A40409|Toad.exe |02640409|tdParamCompletion|TToadParamCompletion |ExecuteAt |801[47] |

|00000040|04 |0675FD84|02A402B4|Toad.exe |026402B4|tdParamCompletion|TToadParamCompletion |DoTimer |724[4] |

|00000040|03 |0675FDB8|00483240|Toad.exe |00083240|System.Classes | |StdWndProc | |

|00000040|03 |0675FDD0|759162FA|USER32.dll|000162FA|USER32 | |(possible gapfnScSendMessage+818)| |

|00000040|03 |0675FDFC|75916D35|USER32.dll|00016D35|USER32 | |(possible GetThreadDesktop+210) | |

|00000040|03 |0675FE74|759177BF|USER32.dll|000177BF|USER32 | |(possible CharPrevW+307) | |

|00000040|03 |0675FED4|75917885|USER32.dll|00017885|USER32 | |DispatchMessageW | |

|00000040|03 |0675FEE4|006B5347|Toad.exe |002B5347|Vcl.Forms |TApplication |ProcessMessage | |