Test, validate and match regular expressions
This regex matches the literal text 'PROCEDURE' followed by any characters, including newlines, until the first closing parenthesis. By utilizing the global and dotall flags (gs), it can effectively scan multiline blocks of code to extract or isolate PL/SQL procedure signatures or definitions. The non-greedy quantifier ensures it captures the shortest possible match.