My Oracle Support Banner

PLS-302 Generating a Procedure with Questions with more than one Occurrence (Doc ID 365632.1)

Last updated on DECEMBER 25, 2019

Applies to:

Oracle Clinical - Version 4.0.3.49 to 4.5.1 [Release 4.0.0 to 4.5.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Regenerating of a procedure fails with the following errors:

--> PACKAGE BODY, 88/40, PLS-00302: component 'COMMENTS' must be declared
--> PACKAGE BODY, 88/16, PL/SQL: Statement ignored-
-> PACKAGE BODY, 114/55, PLS-00302: component 'COMMENTS$RESP_ID' must be declared
--> PACKAGE BODY, 114/19, PL/SQL: Statement ignored
--> PACKAGE BODY, 115/61, PLS-00302: component 'COMMENTS$ENT_TS' must be declared
--> PACKAGE BODY, 115/19, PL/SQL: Statement ignored
--> PACKAGE BODY, 121/61, PLS-00302: component 'COMMENTS$RESP_ID' must be declared
--> PACKAGE BODY, 121/22, PL/SQL: Statement ignored
--> PACKAGE BODY, 132/55, PLS-00302: component 'COMMENTS$RESP_ID' must be declared
--> PACKAGE BODY, 132/19, PL/SQL: Statement ignored-
-> PACKAGE BODY, 133/61, PLS-00302: component 'COMMENTS$ENT_TS' must be declared
--> PACKAGE BODY, 133/19, PL/SQL: Statement ignored
--> PACKAGE BODY, 139/61, PLS-00302: component 'COMMENTS$RESP_ID' must be declared
--> PACKAGE BODY, 139/22, PL/SQL: Statement ignored

----

- COMMENTS is a question in the question group of the DCM included in the procedure.

- There is more than one occurrence of question COMMENTS in the DCM question group, and the new occurrence was added after the procedure was originally compiled.

Changes

The new occurrence of the question was added after the procedure was original generated.

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
Changes
Cause
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.