Oracle - Determine maximum supported size for regular expression

Posted by FrustratedWithFormsDesigner on Stack Overflow See other posts from Stack Overflow or by FrustratedWithFormsDesigner
Published on 2010-04-22T19:57:32Z Indexed on 2010/04/22 20:13 UTC
Read the original article Hit count: 214

Filed under:
|
|

I have a regular expression that throws ORA-12733, "regular expression is too long". How do I determine what the maximum supported size is?

FYI: the offending regex is 892 characters. It's a generated regex, so I could change how I generate and execute it, but I would like to know what the limits to the max size are before I change how I am generating and executing.

(running Oracle 10.2g)

UPDATE:

If it depends on the actual regex, here's the begining of it (the rest is just the same thing repeated, with different values between ^ and $):

(^R_1A$|^R_2A$|^R_3A$|^R_4A$|^R_4B$|^R_5A$|^R_5B$...

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about regex