My Oracle Support Banner

E-SQR: PROCESSING-LIMITS On SQR Should Be Increased (Doc ID 1471890.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 to 8.52 [Release 8.4]
PeopleSoft Enterprise PT PeopleTools - Version 8.59 to 8.59 [Release 8.4]
Information in this document applies to any platform.

Goal

The Processing-Limits section is used to define the sizes and limitations of some of the internal structures used by SQR, which has a direct impact on memory requirements.

Due to the limits, SQR programs with large size tends to exceed the limits. In that case, developer has to divide the program into multiple programs.

It takes the developer a long time to divide such programs.

DYNAMICARGS 32767
PROGLINEPARS 65535
PROGLINES 32767
VARIABLES 32767 
etc.

Is there a workaround to resolve this issue?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.