Using "Find Database Objects" to search for "[ ]*PERSON" with "Regular expressions" checked causes problems for me. After hitting search I get the error "unexpected end of expression", but PLSQL Developer continues to act like it's searching. Trying to close PLSQL Developer gives the message "Find Database Objects Window cannot be closed, Query is still executing". I have to use Task Manager to kill PLSQL Developer.
Find Objects with regular expression causes PLSQL Dev to hang
- Thread starter Worker
- Start date
We'll fix it.
This problem still exists. I don't seem to get the "unexpected end of expression" error anymore, but PLSQL Developer still hangs.
The same also happens with the regular expression "TO_CHAR(".
Also, there seems to be some space-related weirdness with the regular expression search. A search in SYS' package specifications for "TO_CHAR\( " (note the trailing space) finds "TO_CHAR(SYSDATE" (note the missing space). A search in my own package specifications for "TO_CHAR\( SYSDATE" (again, note the space) finds nothing even though it definitely should.
Is the regular expression search completely implemented in PLSQL Developer, or is this using OWA_PATTERN or something else from Oracle other than ALL_SOURCE?
(7.1.1.1339, Oracle 8i)
The same also happens with the regular expression "TO_CHAR(".
Also, there seems to be some space-related weirdness with the regular expression search. A search in SYS' package specifications for "TO_CHAR\( " (note the trailing space) finds "TO_CHAR(SYSDATE" (note the missing space). A search in my own package specifications for "TO_CHAR\( SYSDATE" (again, note the space) finds nothing even though it definitely should.
Is the regular expression search completely implemented in PLSQL Developer, or is this using OWA_PATTERN or something else from Oracle other than ALL_SOURCE?
(7.1.1.1339, Oracle 8i)
This does indeed still need to be addressed.
What error do you get?
Regular expression searching is just a mess when it comes to spaces.
Given a program window with the cursor at the top and the following content:
1. Searching for the regular expression "hello world" (without quotes) does not give a match. Unchecking the "Regular expressions" box or searching for "hello" or "world" separately fixes it.
2. Searching for the regular expression "^ " or " $" (without quotes) gives a match on every line, even though every line does not start nor end with a space. The same thing happens with a pasted tab character instead of a space, but not with "\t" or "\W".
3. Searching for the regular expression "[^ ]+" (without quotes) finds everything, including the space that it shouldn't be looking for.
4. Searching for the regular expression "[ ]+" (without quotes) gives the error "Unexpected end of expression".
Also, searching for the regular expression "(" (without quotes) gives the error "Do not closed sub expression". This is probably fine, but the grammar of the error message does not instill very much confidence.
Given a program window with the cursor at the top and the following content:
Code:
hello world
hello world
hello world1. Searching for the regular expression "hello world" (without quotes) does not give a match. Unchecking the "Regular expressions" box or searching for "hello" or "world" separately fixes it.
2. Searching for the regular expression "^ " or " $" (without quotes) gives a match on every line, even though every line does not start nor end with a space. The same thing happens with a pasted tab character instead of a space, but not with "\t" or "\W".
3. Searching for the regular expression "[^ ]+" (without quotes) finds everything, including the space that it shouldn't be looking for.
4. Searching for the regular expression "[ ]+" (without quotes) gives the error "Unexpected end of expression".
Also, searching for the regular expression "(" (without quotes) gives the error "Do not closed sub expression". This is probably fine, but the grammar of the error message does not instill very much confidence.
Similar threads
- Discussion
