How to pass table name to SP?(p17)

Is there a way to pass a table name to a stored procedure:

PROCEDURE  ADDCODE  (mfilecode CHAR, new_code CHAR, new_desc CHAR) IS
BEGIN
   INSERT INTO mfilecode
      VALUES (new_code, new_desc);
END ADDCODE;


Ans:

You will have to use the dbms_sql package to parse, bind and execute a
dynamic SQL statement.
 

Hosted by www.Geocities.ws

1