Hi, 1. In _v_procedure table, the column createdate does not get updated when SP gets replaced. Is there any way to know when a procedure was last modified? 2. I have a procedure which takes variable number of arguments (created using VARARGS as argument), but when I use nz_ddl_procedure or see the ddl of the SP this info does not gets shown. Where and how can I see this info?
So far as I am aware that information is not recorded anywhere. You would have to first drop the stored procedure then create a new one if you want the create date column to reflect the last time you modified the procedure.
