The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_msg_tbl.DELETE;
G_dep_tbl.DELETE;
PROCEDURE Delete_Msg
( p_msg_index IN NUMBER := NULL
)
IS
l_var varchar2(62);
-- Delete the whole table.
G_msg_tbl.DELETE;
-- Delete the last message table entry.
G_msg_tbl.DELETE(G_msg_count) ;
END Delete_Msg;
FUNCTION Delete_Msg return varchar2
IS
l_message_number number;
Delete_Msg(l_message_number);
END Delete_Msg;