APEX

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