Oracle 通过存储过程调用http服务

-- dba 用户 新增授权ACL
begin
  dbms_network_acl_admin.create_acl (      
    acl         => 'ksh_http.xml',        
    description => 'HTTP Access',          
    principal   => 'SDYDXJ',               
    is_grant    => TRUE,                   
    privilege   => 'connect',              
    start_date  => null,                   
    end_date    => null                    
  );
  dbms_network_acl_admin.add_privilege (   
    acl        => 'ksh_http.xml',          
    principal  => 'SDYDXJ',                
    is_grant   => TRUE,                    
    privilege  => 'resolve',              
    start_date => null,                     
    end_date   => null
  );
  dbms_network_acl_admin.assign_acl (       
    acl        => 'ksh_http.xml',
    host       => '*'  
  );
end;


--dba 用户  删除acl

begin

  dbms_network_acl_admin.drop_acl(

    '/sys/acls/ksh_test.xml'

  );

commit?

end;