Cursor For Loop Returns ORA-06502
(Doc ID 299442.1)
Last updated on OCTOBER 09, 2023
Applies to:
Oracle Forms - Version 10.1.2.0.2 and laterOracle Forms for OCI - Version 12.2.1.3.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
When trying to populate the block using cursors, you sometimes receive an ORA-06502 error.
Even CURSOR columns and the table (into which we are populating data) columns all have the same datatype and precision.
Sometimes the message built-in inside the cursor loop does not execute. Running the same cursor query in SQL*Plus runs fine.
Cause
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
Symptoms |
Cause |
Solution |
References |