• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 661
  • Last Modified:

How to debug and see code for a SQL stored procedure?

I have some procedures which run on BEA Aqua Logic Helper, which give error. In DB Visualiser(6.0.14) I can execute them to see results.

I want to see the code and debug the code. I also need to know where is the logs generated?
How can I use the DBVisualiser or is there any free tool which can simplify the work.
0
jgdvishnu
Asked:
jgdvishnu
  • 3
  • 2
1 Solution
 
sdstuberCommented:
you can query dba_source / all_source / user_source

oracle has it's own gui tool  sql*developer  which is free


http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
0
 
sdstuberCommented:
regardless of the tool, you will need to have privileges on the appropriate dictionary view and/or object


0
 
slightwv (䄆 Netminder) Commented:
>>BEA Aqua Logic Helper

I'm not familiar with this product.  Are these PL/SQL procedures, external Java procedures, or something else?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
jgdvishnuSoftware ArchitectAuthor Commented:
I did not have access to the user_source. but looks like I could do it if I had
0
 
sdstuberCommented:
that's odd,  user_source "should" be public.

most tools use all_source and may have an option to use dba_source

you should talk to your dba about the privileges you'll need

one of these three.

select on all_source

or  select_catalog_role

or  select any dictionary
0
 
slightwv (䄆 Netminder) Commented:
Can I ask why this was closed?  How do you know it will provide what you need once you get access?

If the procedures are pl6sql but could be, and probably are, wrapped and you will be unable to read them.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now