JasperReportsIntegration icon indicating copy to clipboard operation
JasperReportsIntegration copied to clipboard

Error executing last command @user_install.sql

Open alshamynet opened this issue 5 months ago • 4 comments

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>
`

alshamynet avatar Sep 24 '24 10:09 alshamynet