How to fix the Oracle error PCB-00701: MAX OCCURRANCES must be between 1 and 65535?

In this post, you’ll learn more about the Oracle ErrorPCB-00701: MAX OCCURRANCES must be between 1 and 65535 with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCB-00701: MAX OCCURRANCES must be between 1 and 65535

Reason for the Error PCB-00701: MAX OCCURRANCES must be between 1 and 65535

Cause: The value specified in the WITH MAX clause of an EXEC SQL ALLOCATE DESCRIPTOR statement was less than 1 or greater than 65535

How to fix the Error PCB-00701: MAX OCCURRANCES must be between 1 and 65535 ?

You can fix this error in Oracle by following the below steps

Action: Specifiy a value between 1 and 65535 inclusive