We are about to buy Toad primarily for the reason of running code Xpert tool on our PL/SQL code bases. While using the Toad’s evaluation copy, I noticed that even if Toad is run from the command line with the SQL files given, an argument for the database connection credentials has to be provided. I am confused why toad needs a connection to the oracle server when the SQL sources are given.
If I am to use only the Code Xpert tool of Toad, what would be the simplest option to get a code base analyzed and generate an XML or CSV based output? Secondly, is there anyway I can automate this? (Probably by using command line)
Read about toad applications (application manager) and toad actions. Basically
you can automate exactly what you want without having to provide the password
(as it will use your connection definition). And the application/action also
offers scheduling J
If only files were given AND SQL Scan was turned off AND database inserts were
turned off, Toad would not need the connection information. Since we provide the
ability to do all of those things and a user could easily edit the CX ini file
to do those items, we require the login information.
Instructions for running CX via the command line, scheduling, and outputting the
results to XML are in the help file.
I was able to create an XML via command line with connection info.
But even if I turn off
INCLUDE_SERVERSIDE_INSERT
and
SQL_SCAN,
CX still needs the connection info and does not generate the results.
Is this what you meant by “Since we provide the
ability to do all of those things and a user could easily edit the CX ini file
to do those items, we require the login information”
Is there anyway I can run this without the connection info?