Program too large error - what are the limits?

[WexSoft]

Hi Folks

I know that the solution to the "Program Too Large" error is normally to turn off adding debug code when compiling, but I was just wondering if there is a known upper limit before this problem kicks in - in terms of number of lines of code, or file size etc.?

Best regards

Billy

 

[MartinF]

Hi,

The PLS-123 error is not really base on the number of lines of code or file size. This error is usually raise when the program have reach the maximum number of DIANA node allowed.

Here is some documentation that may help you to understand
PLSQL Program Limit

Hope it help

 

[WexSoft]

Hi MartinF

Thanks very much for the information - very helpful.

Best regards

Billy