施用PLSQL 订阅 itpub rss源

使用PLSQL 订阅 itpub rss源
实现功能：

订阅Oracle开发 板块的rss ，根据Title 排重 入库。

附录ORA-24247解决办法
执行前三步

1 .create aclbegindbms_network_acl_admin.create_acl (acl => 'connect_to_world_acl.xml',description => 'CONNECT_TO_WORLD_ACL' ,principal => 'DEXTER',       is_grant => true,privilege => 'resolve');end;/commit ;2. 指定权限begindbms_network_acl_admin.add_privilege (acl => 'connect_to_world_acl.xml',principal => 'DEXTER',is_grant => true,privilege => 'connect');end;/commit ;3. 指派aclbegindbms_network_acl_admin.assign_acl(acl => 'connect_to_world_acl.xml',host => '*');end;/commit ;4. 查询select host, lower_port, upper_port, acl from dba_network_acls;select acl,       principal,       privilege,       is_grant,       to_char(start_date, 'dd-mon-yyyy') as start_date,       to_char(end_date, 'dd-mon-yyyy') as end_date  from dba_network_acl_privileges;select any_path from resource_view where any_path like '/sys/acls/%.xml';5. 删除BEGINDBMS_NETWORK_ACL_ADMIN.drop_acl (acl => 'connect_to_world_acl.xml');COMMIT;END;/


如果想要订阅其他板块，只需要修改v_blog_url 参数即可。