Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Program too large (Diana nodes) while trying to compile a PL/SQL package

antobaySep 14 2017 — edited Sep 21 2017

Please help, I get this error message (Error 123 at line 3475, column 40 - Program too large (Diana Nodes)

There is no error in the package other than the fact that it probably exceeds the number of permitted lines of codes. The total lines for this package is 4218 but I intend to add to this package.

Is there a work-around without breaking the codes into chunks or another package. I asked this because the codes outputs sets of queries into excel workbook adding to the worksheets. If I have to break the codes then I may run into difficulty adding worksheets onto the opened workbook as I intend to have only one workbook with many worksheets

.

I am using webutil ole2 package but this is not the problem. The problem is the length of the codes.

I am running Forms [64 Bit] Version 11.1.2.2.0 (Production) on Windows 7 running on Oracle 12c database.

Ant help will be appreciated.

This post has been answered by Marwim on Sep 15 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2017
Added on Sep 14 2017
10 comments
1,070 views