With the newest release of Toad for Oracle, the object search is broken.
Go to: Search -> Object Search:
Then in the Search Term try seraching for: xyz(‘abc’) toad says: ORA-00907: missing right parenthesis
Use two single quotes where you have one.
Xyz(‘’abc’’)
From: brian_1438 [mailto:bounce-brian_1438@toadworld.com]
Sent: Friday, August 23, 2013 10:05 AM
Subject: [Toad for Oracle - Discussion Forum] Toad Object Search
Thread created by brian_1438
With the newest release of Toad for Oracle, the object search is broken.
Go to: Search -> Object Search:
Then in the Search Term try seraching for: xyz(‘abc’) toad says: ORA-00907: missing right parenthesis
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.
I need to locate the phase: xyz(‘abc’) in the code
xyz is a function name and ‘abc’ is a string being passed to the function. I need to find all packages which call this function.
So changing the search phrase to xyz(“abc”) is not helpful.
The Object Search is clearly broken… try searching for xyx(
This is fixed in Toad 12.1. In the meantime you'll need to properly escape all characters that are special by regex definition.
Try... xyz('abc')
On 08/23/2013 11:14 AM, brian_1438 wrote:
Reply by brian_1438
I need to locate the phase: xyz('abc') in the code
xyz is a function name and 'abc' is a string being passed to the function. I need to find all packages which call this function.
So changing the search phrase to xyz("abc") is not helpful.
The Object Search is clearly broken.... try searching for xyx(
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.
...And you may also need to double up the quotes too if escaping the parens alone doesn't do it.
On 08/23/2013 11:14 AM, brian_1438 wrote:
Reply by brian_1438
I need to locate the phase: xyz('abc') in the code
xyz is a function name and 'abc' is a string being passed to the function. I need to find all packages which call this function.
So changing the search phrase to xyz("abc") is not helpful.
The Object Search is clearly broken.... try searching for xyx(
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.
Oops, sorry for the bad advice.
I can reproduce this in 12.0, but it is fixed in the current beta and will be fixed in 12.1.
You can get the beta here
http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/default.aspx
From: brian_1438 [mailto:bounce-brian_1438@toadworld.com]
Sent: Friday, August 23, 2013 10:15 AM
Subject: RE: [Toad for Oracle - Discussion Forum] Toad Object Search
Reply by brian_1438
I need to locate the phase: xyz(‘abc’) in the code
xyz is a function name and ‘abc’ is a string being passed to the function. I need to find all packages which call this function.
So changing the search phrase to xyz(“abc”) is not helpful.
The Object Search is clearly broken… try searching for xyx(
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.
Thank you!!! This is has been driving me crazy for weeks!!!