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

Last updated on NOVEMBER 04, 2008

Applies to:

Oracle Clinical - Version: 4.0.3.1
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

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