Query to find invalid routines on a 5.7.2 database
Hi all
Where can I find the STATUS of my procedures and functions belong to my database?
I need to know this through a query.
I found this query but this doesn't have a column describing INVALID or something like that.
SELECT *
FROM information_schema.routines
WHERE routine_schema = 'MYDB'
ORDER BY routine_name;
Please would you send me a query in order to know which routine is INVALID?
thanks in advanced.
regards
Subject
Written By
Posted
Query to find invalid routines on a 5.7.2 database
March 23, 2023 10:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.