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