May be use the table name as parameter to the dbprocedure? For example:

CREATE DBPROC del_record (IN id FIXED(6), IN table_name VARCHAR(32))
AS
BEGIN
UPDATE :table_name SET status = 1 WHERE id = :id;
END;

Pavel Konovalov
________________________________
JS RCOM, Russia 
http://www.rscom.ru



_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to