Toad World® Forums

Toad Object Search

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

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Toad Object Search

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:

RE: 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.

…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:

RE: 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.

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

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Toad Object Search

RE: 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!!!