Help: Very simple PL/SQL question...

Hi,
I need to create a PL/SQL procedure that accepts the name of a table and issues an SQL statement to that table. Something like

CREATE OR REPLACE PROCEDURE DeleteRecord (

     p_id NUMBER, p_table_name VARCHAR2
)
AS
BEGIN
 DELETE FROM p_table_name WHERE id = p_id;  COMMIT;
END;
/

How do I say that "p_table_name" is a variable and not the name of a table? Sorry for this simple question...,
Araxes Received on Sat May 26 2001 - 12:06:25 CDT