Package rss_util_pkg

Variables, constants

const g_format_rss

g_format_rss constant varchar2(10):='rss'

this is a simplification see http://en.wikipedia.org/wiki/RSS#Variants see http://www.tutorialspoint.com/rss/rss-quick-guide.htm

const g_format_rdf

g_format_rdf constant varchar2(10):='rdf'

const g_format_atom

g_format_atom constant varchar2(10):='atom'

Functions, procedures

function ref_cursor_to_feed

function ref_cursor_to_feed(
    p_ref_cursor in sys_refcursor,
    p_feed_title in varchar2,
    p_feed_description in varchar2:=null,
    p_feed_link in varchar2:=null,
    p_feed_date in date:=null,
    p_format in varchar2:=null
) return clob

ref cursor to rss

function rss_to_list

function rss_to_list(
    p_feed in clob,
    p_format in varchar2:=null
) return t_feed_item_list

rss feed to list

function rss_to_table

function rss_to_table(
    p_feed in clob,
    p_format in varchar2:=null
) return t_feed_item_tab

rss feed to table rows

Types

record t_feed_item

type t_feed_item is record(
    item_guid varchar2(255),
    item_title varchar2(4000),
    item_description varchar2(4000),
    item_link varchar2(4000),
    item_date date
)

varray t_feed_item_list

type t_feed_item_list is varray of t_feed_item index by binary_integer

varray t_feed_item_tab

type t_feed_item_tab is varray of t_feed_item