![]() ![]() ![]() ![]() Below two conditions should be deleted after testing simple sampleĬALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('PROCEDURE', ROW.PROC_SCHEMA, ROW.PROC_NAME) ĮND Simulate: procedure admin.sp becomes not valid after below commandĭROP TABLE After above command procedure ADMIN.SP is not valid anymore Below two conditions, just to simulate our stored procedure in case if tested on database with other non valid procedures WHERE ROUTINESCHEMA = 'ADMIN' AND ROUTINENAME = Create procedure to get all of the procedures on database that are in not valid state and validate them with sysproc.admin_revalidate_db_objects system procedure.ĬREATE OR REPLACE PROCEDURE ADMIN.VALIDATE CREATE TABLE ADMIN.TAB (A Sample stored procedureĭELETE FROM Check if above procedure is valid, it should be ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |