daust
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>
`
Oracle APEX is not installed. It has a dependency on the v() function and apex_util.url_encode.
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 .
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.