On Wed, 20 Jun 2001 11:51:56 -0400, Bob Powell wrote: >Can anyone on this list serv give me a reason as to >why I shouldn't deleted procedures directly from the >sys_procedures table when I want to remove them? Well, for one, it is a lot easier to do: DROP PROCEDURE procedurename than it is to do: DELETE FROM SYS_PROC_COLS + WHERE SYS_PROC_ID = + (SELECT SYS_PROC_ID FROM SYS_PROCEDURES + WHERE SYS_PROC_NAME = 'procedurename') DELETE FROM SYS_PROCEDURES + WHERE SYS_PROC_NAME = 'procedurename' Bill
