Hi,
We're using Oracle 12c,
We compiled the specs and body for the Oracle OS_COMMAND package on our Dev platform and the package compiled just fine.
We then compiled it on our UAT system and we get the following errors:
xdt827db01_cdb621a1> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDBSLD02A READ WRITE NO
xdt827db01_cdb621a1> @OS_Command_1.sql
Warning: Package created with compilation errors.
xdt827db01_cdb621a1> show error
Errors for PACKAGE SYS.OS_COMMAND:
LINE/COL ERROR
-------- -----------------------------------------------------------------
3/3 PL/SQL: Declaration ignored
3/43 PLS-00201: identifier 'FILE_TYPE' must be declared
5/3 PL/SQL: Declaration ignored
5/35 PLS-00201: identifier 'FILE_TYPE' must be declared
xdt827db01_cdb621a1> @OS_Command_2.sql
Warning: Package Body created with compilation errors.
xdt827db01_cdb621a1> show error
Errors for PACKAGE BODY SYS.OS_COMMAND:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/18 PLS-00304: cannot compile body of 'OS_COMMAND' without its
specification
1/18 PLS-00905: object SYS.OS_COMMAND is invalid
xdt827db01_cdb621a1>
Same code, different system. I even had the guy take the exact code from the ticket he used to install the procedure on the DEV box and it still gave the error. We changed nothing.
Also I made sure he ran the specs package first and then the body package.
Is there anything we missed