Error executing last command @user_install.sql

[alshamynet]

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

[daust]

Oracle APEX is not installed. It has a dependency on the v() function and apex_util.url_encode.

[alshamynet]

Thank you sir, but I found a video on YouTube explaining how to do it and I liked the idea, but unfortunately the process was not successful. Here is the video link : https://www.youtube.com/watch?v=4gS0prtUGWI&list=LL&index=1&t=435s If you can give me a solution .

[alshamynet]

I use this jri-2.11.0-jasper-6.20.6

[daust]

Well, the instructions look good. It is just that the current implementation has a dependency on Oracle APEX, it uses the package APEX_UTIL and the function v().

Therefore, you would have to have APEX installed in the database so that it can resolve those functions.

How do you want to use the JasperReportsIntegration? You didn't really respond to my last comment. Thank you.