Hi all ,
in new with ACL and ive got some issues here please ,
i'm started the step over my DB and to make HTTP/HTTPS web request to provide the
ability to communicate to the outside world.
from this site : ORACLE-SOLUTIONS - Oracle 11g Acces Control List ORA-24247.
and im now stuck right befor end to check the ACL priviliges -
i yting run this and iv'e got this error :
---------------------------------------------------------------------------------------------------
Error starting at line : 200 in command -
begin
dbms_network_acl_admin.assign_acl(
acl => 'utl_http.xml',
host => 'www.tiger.com',
lower_port => 80,
upper_port => 80);
end;
Error report -
ORA-06550: line 2, column 2:
PLS-00103: Encountered the symbol " " when expecting one of the following:
( begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
json_exists json_value json_query json_object json_array
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
------------------------------------------------------------------------------------------------
i ran these command in separate :
------------------------------------------------
begin
dbms_network_acl_admin.create_acl (
acl => 'utl\_http.xml',
description => 'HTTP Access',
principal => 'SCOTT',
is\_grant => TRUE,
privilege => 'connect',
start\_date => null,
end\_date => null
);
end;
-------------------------------------------------
And :
-------------------------------------------------
begin
dbms_network_acl_admin.add_privilege (
acl => 'utl\_http.xml',
principal => 'SCOTT',
is\_grant => TRUE,
privilege => 'resolve',
start\_date => null,
end\_date => null
);
end;
----------------------------------------------
the 2 commands was successfully run,
but the error that im got is on this command :
-----------------------------------------------
begin
dbms_network_acl_admin.assign_acl (
acl => 'utl\_http.xml',
host => 'www.tiger.com',
lower\_port => 80,
upper\_port => 80
);
commit;
end;
-------------------------------------------
any one encountered with these issue ?
i cant continue the steps,
@"thatJeffSmith-Oracle"
any help will help,
thanks,
regards.