Getting following errors
install PL/JSON
***********************************************************************************
-----------------------------------
-- Compiling objects for PL/JSON --
-----------------------------------
PL/SQL procedure successfully completed.
Type created.
Type created.
No errors.
Type created.
No errors.
Type created.
No errors.
Warning: Package created with compilation errors.
Warning: Package Body created with compilation errors.
Warning: Package created with compilation errors.
Warning: Package Body created with compilation errors.
Warning: Type Body created with compilation errors.
Errors for TYPE BODY FX_JSON_VALUE_T:
LINE/COL ERROR
-------- -----------------------------------------------------------------
139/7 PL/SQL: Statement ignored
139/14 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
141/7 PL/SQL: Statement ignored
141/14 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
148/7 PL/SQL: Statement ignored
148/7 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
150/7 PL/SQL: Statement ignored
150/7 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
159/5 PL/SQL: Statement ignored
159/5 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
160/5 PL/SQL: Statement ignored
LINE/COL ERROR
-------- -----------------------------------------------------------------
160/49 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
169/5 PL/SQL: Statement ignored
169/5 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
170/5 PL/SQL: Statement ignored
170/5 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
Warning: Package created with compilation errors.
Warning: Package Body created with compilation errors.
Warning: Type Body created with compilation errors.
Errors for TYPE BODY FX_JSON_T:
LINE/COL ERROR
-------- -----------------------------------------------------------------
17/9 PL/SQL: Statement ignored
17/17 PLS-00905: object FOEX_220203.FX_P_JSON_PARSER is invalid
25/5 PL/SQL: Statement ignored
25/13 PLS-00905: object FOEX_220203.FX_P_JSON_PARSER is invalid
260/7 PL/SQL: Statement ignored
260/14 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
262/7 PL/SQL: Statement ignored
262/14 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
269/7 PL/SQL: Statement ignored
269/7 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
271/7 PL/SQL: Statement ignored
LINE/COL ERROR
-------- -----------------------------------------------------------------
271/7 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
280/5 PL/SQL: Statement ignored
280/5 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
281/5 PL/SQL: Statement ignored
281/49 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
291/9 PL/SQL: Statement ignored
291/18 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
292/9 PL/SQL: Statement ignored
292/9 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
Warning: Type Body created with compilation errors.
Errors for TYPE BODY FX_JSON_LIST_T:
LINE/COL ERROR
-------- -----------------------------------------------------------------
11/5 PL/SQL: Statement ignored
11/13 PLS-00905: object FOEX_220203.FX_P_JSON_PARSER is invalid
17/5 PL/SQL: Statement ignored
17/13 PLS-00905: object FOEX_220203.FX_P_JSON_PARSER is invalid
202/7 PL/SQL: Statement ignored
202/14 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
204/7 PL/SQL: Statement ignored
204/14 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
211/7 PL/SQL: Statement ignored
211/7 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
213/7 PL/SQL: Statement ignored
LINE/COL ERROR
-------- -----------------------------------------------------------------
213/7 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
222/5 PL/SQL: Statement ignored
222/5 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
223/5 PL/SQL: Statement ignored
223/49 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
232/5 PL/SQL: Statement ignored
232/5 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
233/5 PL/SQL: Statement ignored
233/5 PLS-00905: object FOEX_220203.FX_P_JSON_PRINTER is invalid
and then further
Comment created.
Comment created.
Warning: Trigger created with compilation errors.
Warning: Trigger created with compilation errors.
Warning: Trigger created with compilation errors.
Warning: Trigger created with compilation errors.
View created.
View created.
….
old 7: ( '^FXENV_FOEX_VERSION'
new 7: ( '22.2.0.3'
old 8: , ^FXENV_FOEX_VERSION_NO
new 8: , 220203
insert into fx_t_version
*
ERROR at line 1:
ORA-04098: trigger 'FOEX_220203.FX_T_VERSION_BIU' is invalid and failed
re-validation
Help: https://docs.oracle.com/error-help/db/ora-04098/
Disconnected from Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free
Version 23.26.1.0.0
All triggers are invalid and can't compile them