Article - CS314510
ERROR: "PLS-00201: identifier 'xxx' must be declared ORA-06550: line 1, column 8:PL/SQL: Statement ignored" during dbpatch -u all in Servigistics Click Parts Planning (C-Parts)
Modified: 03-Oct-2019
Applies To
- Servigistics Click Parts Planning 7.7.2 to 7.7.2.1
Description
- dbpatch -u all
- checking script access for database owner...
OK.
checking programmatic database access...
OK.
checking jdbc database access...
OK.
Patching a PARTS database.
You have requested to patch the pxppdb database.
S99 is already at its highest level (7.7.55).
You have specified the Update option. No database patches
will be applied for this option.
All stored procedures, java stored procedures, triggers, views,
functions, and static data will be reloaded.
This process will update your database. It is CRITICAL
that your database has been backed up first, in case of
difficulties while executing this process.
OK to continue [Y]?
Unable to locate configuration file: C:/Click/parts/work/spoprd/corba/sql/xxx_config.ora
Using default configuration file:
C:/Click/parts/7.7/corba/etc/field_config.ora
Any new database objects will be created in the tablespace: XXX
Do you want to continue [Y]?
Log file (in C:/Click/parts/work/xxx/corba) ? [patch.log]
========================================
== STEP 1: Drop Triggers/Views/etc. ==
========================================
Dropping java resources . . .
Dropping java stored procedures . . .
Error while getting status of jar CausalCodeToY55
ORA-06550: line 1, column 25:
PLS-00302: component 'JAR_STATUS' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
Error while getting status of jar CausalCodeToY55$CausalCode
ORA-06550: line 1, column 25:
PLS-00302: component 'JAR_STATUS' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
Error while getting status of jar DataValidator
ORA-06550: line 1, column 25:
PLS-00302: component 'JAR_STATUS' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
Error while getting status of jar FixPartParent
ORA-06550: line 1, column 25:
PLS-00302: component 'JAR_STATUS' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored ...
- checking script access for database owner...
This is a printer-friendly version of Article 314510 and may be out of date. For the latest version click CS314510