JasperReportsIntegration
JasperReportsIntegration copied to clipboard
Error executing last command @user_install.sql
Hello everyone When the last operation is reached, errors appear stating that the package XLIB_JASPERREPORTS is not installed, and I do not know why? Any help?
`~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~ Package Bodies
Package body created.
No errors.
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY "XLIB_JASPERREPORTS":
LINE/COL ERROR
-------- -----------------------------------------------------------------
191/7 PL/SQL: Statement ignored
191/44 PLS-00201: identifier 'V' must be declared
192/7 PL/SQL: Statement ignored
192/49 PLS-00201: identifier 'V' must be declared
330/7 PL/SQL: Statement ignored
330/45 PLS-00201: identifier 'APEX_UTIL.URL_ENCODE' must be declared
336/10 PL/SQL: Statement ignored
336/46 PLS-00201: identifier 'APEX_UTIL.URL_ENCODE' must be declared
339/10 PL/SQL: Statement ignored
339/46 PLS-00201: identifier 'APEX_UTIL.URL_ENCODE' must be declared
430/7 PL/SQL: Statement ignored
LINE/COL ERROR
-------- -----------------------------------------------------------------
430/45 PLS-00201: identifier 'APEX_UTIL.URL_ENCODE' must be declared
436/10 PL/SQL: Statement ignored
436/46 PLS-00201: identifier 'APEX_UTIL.URL_ENCODE' must be declared
439/10 PL/SQL: Statement ignored
439/46 PLS-00201: identifier 'APEX_UTIL.URL_ENCODE' must be declared
Package body created.
No errors.
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY "XLIB_LOG":
LINE/COL ERROR
-------- -----------------------------------------------------------------
13/7 PL/SQL: SQL Statement ignored
21/34 PL/SQL: ORA-00904: "V": invalid identifier
*** grant xlib_jasperreports_img to public
Grant succeeded.
~~ recompile schema
begin
*
ERROR at line 1:
ORA-20001: Cannot recompile SYS objects
ORA-06512: at "SYS.DBMS_UTILITY", line 387
ORA-06512: at line 2
~~ any invalid objects?
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-----------------------
XLIB_JASPERREPORTS
PACKAGE BODY
XLIB_LOG
PACKAGE BODY
Commit complete.
SQL>
`