# Running Toad Code Xpert seperately

**URL:** <https://forums.toadworld.com/t/running-toad-code-xpert-seperately/9841>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [September 20, 2010, 8:43am UTC](https://forums.toadworld.com/t/running-toad-code-xpert-seperately/9841 "2010-09-20T08:43:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![chandima\_j1988\_984](https://avatars.discourse-cdn.com/v4/letter/c/f07891/32.png) [@chandima\_j1988\_984](https://forums.toadworld.com/u/chandima_j1988_984)\
**Post date:** [September 20, 2010, 8:43am UTC](https://forums.toadworld.com/t/running-toad-code-xpert-seperately/9841/1 "2010-09-20T08:43:30Z")

</div>

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)

Highly appreciate your help? Thanks in advance…

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [September 20, 2010, 8:43am UTC](https://forums.toadworld.com/t/running-toad-code-xpert-seperately/9841/2 "2010-09-20T08:43:30Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [September 20, 2010, 8:50am UTC](https://forums.toadworld.com/t/running-toad-code-xpert-seperately/9841/3 "2010-09-20T08:50:38Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![chandima\_j1988\_984](https://avatars.discourse-cdn.com/v4/letter/c/f07891/32.png) [@chandima\_j1988\_984](https://forums.toadworld.com/u/chandima_j1988_984)\
**Post date:** [September 21, 2010, 2:00am UTC](https://forums.toadworld.com/t/running-toad-code-xpert-seperately/9841/4 "2010-09-21T02:00:07Z")

</div>

Thanks alot.But need to clarify one more thing.

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?

---

<div class="post-metadata">

**Author:** ![chandima\_j1988\_984](https://avatars.discourse-cdn.com/v4/letter/c/f07891/32.png) [@chandima\_j1988\_984](https://forums.toadworld.com/u/chandima_j1988_984)\
**Post date:** [September 21, 2010, 3:11am UTC](https://forums.toadworld.com/t/running-toad-code-xpert-seperately/9841/5 "2010-09-21T03:11:12Z")

</div>

Appreciate your help…
