RE: CodeXpert

For 11.1, we support parameter files in the CA Action so you could make a generic CA action, create the parameter file and then update that file with your desired script(s) each time you want to run CA via the command line.  Is this the kind of thing you're looking for?

Greg

From: [email protected] [mailto:[email protected]] On Behalf Of idba
Sent: Tuesday, January 24, 2012 12:49 PM
To: [email protected]
Subject: [toad] CodeXpert





Message from: idba


Hi,

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?

Thanks!

_______________________________________

Historical Messages


Author: idba
Date: Tue Jan 24 09:49:21 PST 2012
Hi,

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?

Thanks!
__
_______________________________________