Results 1 to 2 of 2

Thread: Debug?

  1. #1
    Join Date
    Feb 2005
    Location
    Barcelona
    Posts
    42

    Question Unanswered: Debug?

    How could I get the execution debug of a function, procedure, trigger...
    from SQL*Plus? I need to get something like execution trace...

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    From SQL*Plus? You can't trace execution of a single SQL statement (for example, something like "now Oracle selects data from first table, now it performs join, now it is ordering data by some criteria", etc.).

    You could, however, trace execution of a PL/SQL block. Not very elegant, but can be done - using DBMS_OUTPUT.PUT_LINE statement where appropriate (for example, before entering the FOR loop and after it finishes, before insert into some table, etc.).

    This can be done in a GUI environment using a tool which provides such a functionality; one of them is Oracle SQL Developer, free to download and use.

Posting Permissions

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