My Oracle Support Banner

Cursor For Loop Returns ORA-06502 (Doc ID 299442.1)

Last updated on OCTOBER 09, 2023

Applies to:

Oracle Forms - Version and later
Oracle Forms for OCI - Version and later
Information in this document applies to any platform.
This problem can occur on any platform.


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.


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

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