Incorrect Order Of Generated Code Using A Cursor Gives Pls-00320 Pls-00320 (Doc ID 262956.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Designer - Version: 6.5.94.3
This problem can occur on any platform.

Symptoms

Generated PL/SQL Procedure containing a Program Data (variable) that references a Sub Program (Cursor), will fail to execute on the database with error:
PLS-00320: the declaration of the type of this expression is incomplete or malformed.

The cursor should be defined above the variable which references it i.e. the Sub-Program Unit should come before the Program Data.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms