About Object Search Results in Toad

[sarahwang]

Hi everyone,

My version is 2026 R2.

I'm testing the Source Search feature and have noticed two things that I'm not sure about.

1. Why are stored procedures without DBMS_OUTPUT.PUT_LINE included in the search results?

I searched for DBMS_OUTPUT.PUT_LINE and selected Occurs anywhere, but ADD_JOB_HISTORY and SECURE_DML still appeared in the results, even though neither procedure contains any DBMS_OUTPUT.PUT_LINE statements. These two procedures are part of the HR sample schema.

Is this expected behavior, or am I missing something?

2. Why doesn't Exact match return any results?

When I select Exact match, no results are returned. This seems inconsistent with the behavior described in the Toad Help documentation, which says that Exact match searches for an exact match in Oracle 10gR2 and later.

Has anyone experienced the same behavior or knows why this might happen?

Thanks in advance for any help.

[JohnDorlon]

You are putting your search term in the wrong field, and you have checked "search object names" but that shouldn't be checked because you just want to search source code. Set it up like this.

Note that the edit box in the "source search" box is to further limit search results by object name.

[sarahwang]

Really helpful. Thank you so much!

By the way, I’d also like to understand how to use “LIKE - Escape \” and how it affects the search results.

[JohnDorlon]

Like Escape allows you to search for underscore characters specifically, rather than treating underscore as a single-character wildcard.

Our SQL is like this when you use it:

WHERE UPPER(object_name) like :SearchTerm ESCAPE '\'

So if you put in DBA\_% as your search term, then it will find DBA_TABLES but not DBATABLES

-John

[sarahwang]

Thank you for the tips~~
I was able to test out most of the features and filtering options in Object Search.