CREATE PROCEDURE ABC (P_TABLE_NAME VARCHAR2) AS
SQL VARCHAR2(4000);
BEGIN
SQL := 'INSERT INTO '||P_TABLE_NAME||' VALUES (''A'')';

EXECUTE IMMEDIATE SQL;
END;