57: end delete_rows;
58:
59:
60: procedure delete_rows
61: (p_rowids in dbms_sql.varchar2s
62: ) is
63: begin
64: if p_rowids.count = 0 then
65: return;
81: end delete_row;
82:
83: ----------------------------- fetch_all_rows -----------------------------
84: procedure fetch_all_rows
85: (p_rowids out nocopy dbms_sql.varchar2s
86: ,p_messages out nocopy dbms_sql.varchar2_table
87: ) is
88: begin
89: select rowid
82:
83: ----------------------------- fetch_all_rows -----------------------------
84: procedure fetch_all_rows
85: (p_rowids out nocopy dbms_sql.varchar2s
86: ,p_messages out nocopy dbms_sql.varchar2_table
87: ) is
88: begin
89: select rowid
90: , message_text bulk collect