SRW procedure gets ORA-24247: network access denied by access control list (ACL)
My database version is :
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Running on ubuntu 11.
I am trying to run a report on another machine with OracleAs reports version 10.1.2.0.2 running on a CentOs 5.5
The SRW procedure is as follow:
create or replace
PROCEDURE REPORT_TEST is
myplist SRW_PARAMLIST;
myident srw.job_ident;
mystatus srw.status_record;
BEGIN
---srw.start_debugging;
myplist := srw_Paramlist(srw_Parameter('',''));
srw.add_Parameter(myplist, 'GATEWAY','http://iastest:7777/reports/rswservlet')