6 Replies Latest reply: Feb 28, 2013 5:01 AM by prog RSS

    Jasper reports integration with apex

    prog
      Hi

      I have apex 4.0.2 installed and we are working without any problem. I have installed ireport designer and designed my report and connected it to my apex using JDBC. then I downloaded apache tomcat 7 for the integration with changing the port.

      I have downloaded Jasperreportsintegration 1.3.0 and installed it in my workspace using the import icon.it has been installed successfully but it's giving me this Installation status in the installation tab:

      failed to parse SQL query:
      ORA-00942: table or view does not exist

      I also didn't follow the steps mentioned there :
      Step 1: Grant execute on utl_http      
      In order to call the JasperReportsIntegration from the database, you need execute privileges on sys.utl_http.




      1- I don't know how to do that.please help me

      2- where should I copy my reports into tomcat?

      3- is there a missing step like installing jasper library somewhere

      4-when ever I try to connect as sysdba i get ORA-01031: insufficient privileges

      Thank you