Code analysis in TOAD

Toad for Oracle
1

Dear All,

I am new to code analysis…

Could you please guide me, How to schedule a job, which will automatically analyse the plsql code (.sql file) using “code analysis” and generates a xml report file in toad.

please you respond asap…I am stuck up with this

Thanks in advance

Vinod

2

Here is a link to a video that shows how you can automate the code analysis process in Toad. Hopefully that can get that you going and if you have any further needs go ahead and reply with them and we’ll have more experts coming online in a few hours.

www.toadworld.com/…/282.aspx

3

You need to learn about Toad’s App Designer – which allows you to define a “macro” of sorts for most screens within toad – they are referred to as actions.
You can then invoke toad via command line to run the app and its actions. Since you can do this via command line – you can obviously then schedule it using Windows scheduler.

Here are some blogs that describe some of these concepts you need to learn. You’ll need to read them and connect the dots – i.e. the examples are not for code
analysis, but it’s the exact same process.

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/09/21/task-automation-in-toad-174-saving-you-hours.aspx

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2011/12/06/using-automation-designer-for-everyday-tasks.aspx

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2008/12/05/happy-holidays-a-toad-appsdesigner-app-just-for-you.aspx

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/04/19/automated-toad-db-health-check-via-email.aspx

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/05/03/automated-toad-db-health-check-via-email-part-2.aspx

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/05/14/quick-intro-to-toad-command-line.aspx

4

Hi all thank you very much for your help…

I have one more question:

When I scedule a job to code analysis the results are not stored in to the DB

but if do it manually I would able to store into the DB…

can you please help me…why code analysis results are not stored in to DB when I schedule a job…

Thanks,

in advance

5

Hello all,

Continuation to above question…

I am getting below error when schedule the Job for code analysis.

“Password not specified. Command line execution requires a saved password on the login screen, an overridden connection using the -c command line option, or a parameter file. Refer to the help for more information.”

please help me ASAP

Thanks in advance

6

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/05/14/quick-intro-to-toad-command-line.aspx

From: vinodkm [mailto:bounce-vinodkm@toadworld.com]

Sent: Monday, September 02, 2013 8:09 AM

To: oracle@toadworld.com

Subject: RE: [Toad World - Oracle Discussion Forum] Code analysis in TOAD

RE: Code analysis in TOAD

Reply by vinodkm

Hello all,

Continuation to above question…

I am getting below error when schedule the Job for code analysis.

“Password not specified. Command line execution requires a saved password on the login screen, an overridden connection using the -c command line option, or a parameter file. Refer to the help
for more information.”

please help me ASAP

Thanks in advance

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Oracle notifications altogether.

Toad World - Oracle Discussion Forum

Flag
this post as spam/abuse.

7

On 02/09/13 14:07, vinodkm wrote:

"Password not specified. Command line execution requires a saved
password on the login screen, an overridden connection using the -c
command line option, or a parameter file. Refer to the help for more
information."
You have three options:

  1. Login through Toad, to the user you wish to schedule the code analysis for. On the new session dialogue, opt to save the password. That will allow you to login to that user, as scheduled, without requiring a password.
  2. On the scheduled task's command line, use the -c option to specify connection details.
    ... -c schema/password@db ...
    OR;
    ... -c "schema2/password@db as sysdba" ...
    Whichever you need to be doing the analysis as.
  3. Use a parameter file, and specify that on the command line for the scheduled task.
    Search Toad's help for "Action Parameter Files" for the gory details on this option.
    HTH
    -- Cheers,
    Norm. [TeamT]
8

On 02/09/13 14:35, Norm [TeamT] wrote:

*Re: Code analysis in TOAD
You have three options:
...
Alternatively, and probably the best option of all, is to read this article - http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/05/14/quick-intro-to-toad-command-line.aspx - on Toadworld. Bert wrote it.
HTH
-- Cheers,
Norm. [TeamT]