Find a ( in a procedure cause PL to hang

DLGL

Member²
Hi,

I don't know if it was reported ?

If you try to find an open parenthesis ( in a procedure PL seems to hang, was not patient enough to wait ;-)

Using version 13.0.2.1898 64 bits.

Same test in version 13.0.1 works ok.

Thanks !

 
Last edited:
Hi Marco,

I found that Regular Expression was on ! When off everything is okay.

If you turn on Regular Expression and the procedure has around 10 lines, it is going ta take a long time. But it will eventually come back.

The procedure I was editing is around 1000 lines.

Is it normal to take so much time using regular expression ?
Searching a normal word ex: BEGIN is fast.

Same with 13.01.

Thank you !
 
I hit this every time I accidentally leave an unescaped and unmatched bracket in a Regular Expression search, e.g.

Code:
nvl(\w+\.version_no

when what I meant to search for was

Code:
nvl\(\w+\.version_no

Instead of reporting it immediately as an invalid regex (as for example Notepad++ or Oracle regexp_ functions would do), it hangs for ages. This still happens in 14.0.6.

And if you are revisiting REs, it would be super handy if we didn't have to escape the space character (again, similarly to Notepad++ and Oracle regexp_ functions).
 
Back
Top