Re: RE: CodeXpert

 Message from: idba

Hi, Greg,

i thank your help!
it is exactly what i need. Is there a way to return a kind of score to classify the procedure as poor, medium ou high quality code?
When will Toad 11.1 become commercial?

Thanks in advance.

Ligia

_______________________________________

Historical Messages 


Author: idba
Date: Thu Jan 26 11:26:38 PST 2012
Hi, Greg,

i thank your help!
it is exactly what i need. Is there a way to return a kind of score to classify the procedure as poor, medium ou high quality code?
When will Toad 11.1 become commercial?

Thanks in advance.

Ligia
__

Author: Gregory Liss
Date: Wed Jan 25 04:45:48 PST 2012




 

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


__

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!
__
_______________________________________