Oracle Reports (MOSC)

MOSC Banner

SRW procedure gets ORA-24247: network access denied by access control list (ACL)

edited Feb 24, 2012 4:02AM in Oracle Reports (MOSC) 16 commentsAnswered ✓
HI,

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')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center