SQL*Plus (MOSC)

MOSC Banner

ACL Lists ... sqlplus on remote server

edited Oct 5, 2018 5:00AM in SQL*Plus (MOSC) 7 commentsAnswered

Hi there

I try to use utl_http via sqlplus and I have the following situation:

Server A:

Oracle 12.2.0.1 SID: TEST

sqlplus  installed

Server B:

sqlplus installed

Server A: SID=TEST

SQL> BEGIN

      dbms_network_acl_admin.append_host_ace(

      host => 'balooweb.xxx.xx',

      lower_port => null,

      upper_port => null,

      ace => xs$ace_type(privilege_list => xs$name_list('connect','resolve','http'),

                       principal_name => 'TSTUSER',

                       principal_type => xs_acl.ptype_db) );

EXCEPTION WHEN OTHERS THEN

  DBMS_OUTPUT.PUT_LINE('Error while granting ACL :'|| SQLERRM);

END;

/

SQL>connect TSTUSER;

SQL> select utl_http.request ('http://balooweb.xxx.xx:8889/') from dual;

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