DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Debug......

Hybrid View

  1. #1
    Join Date
    Feb 2003
    Posts
    69

    Debug......

    Can any one tell me that how to debug the Procedure...
    HTML

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    'show errors' at the sql prompt.

    HTH.

  3. #3
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    show errors will give syntax errors if procedure didn't compile successfully.

    If you get wrong results, you can help yourself by putting some
    "dbms_output.put_line" in the code to see what/how it executes.

    Or if you want more, check dbms_debug.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Scott Urman in the Oracle Press "PL/SQL Programming" Ch18 has a nice simple routine for writing out debuging info during execution (sorry, can't post it for copyright reasons - couldn't find it on the Web). It writes with UTL_FILE doing a FFLUSH after each line to ensure you never loose stuff in buffers.

    The great adavantage is that if you set up some kind of parameter to switch it off/on, you can leave it in place even for the production system. So the day your code works fine in test but fails in prod, you will have some handle on it.

    The DBMS_ solutions aren't easy (possible?) to run in production, especially if you have a 3rd party front-end.

  5. #5
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    You can use JDeveloper for debugging PL/SQL procedures.
    -- Dilip

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width