hello,
I want to validate an input parameter against a table that has a list of table names and throws an exception. what is the best practice/way?
PROCEDURE insert(p_table_name IN list.table_name%TYPE) AS
variables....
BEGIN
IF (Need suggestion)
EXCEPTION WHEN OTHERS THEN null;
END;