in our company, we have a stored procedures publisher that receives a .SQL file and create procedures, packages, etc in datavase without checking anything. Our request now is to create a way to verify procedures (quality of the code, there is no necessity to connect to db) before creating them.
I liked so much of Code Analysis but I could not find a way to run it without creating a project and action. It makes my proposal unfeasible.
It trere a way to call codexpert through command line sending the .SQL file as a parameter and gets a score of the stored procedure code?