Results 1 to 3 of 3

Thread: Error routine

  1. #1
    Join Date
    May 2009

    Unanswered: Error routine

    DBMS_UTILITY.format_call_stack function gets the error throwing procedure.

    When concurrent users or concurrent session is getting from the procedure from stack, will it be session based?

    same user A, has 2 sessions
    Session1 has executed procedure1, which throws exception, the procedure1 is in the stack.
    At the same time, Session2 has executed procedure2, which throws exception, that procedure2 also in the stack.

    For session1, when i capture the error-throwing procedure from stack, which procedure it will be captured procedure1 or procedure2?

    All I want to know is,Stack stores the procedure in session-based?


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >All I want to know is,Stack stores the procedure in session-based?
    Yes, session based.

    >same user A, has 2 sessions
    It depends upon exactly what is meant by "user".

    In some/many/most commercial applications, a single schema owns the whole application and this schema owns some/many/most sessions within the database.
    Each session can & will produce its own error stack.
    Last edited by anacedent; 06-06-09 at 11:50.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2009
    Is there is any relevant website link is there? Please let me that i can also refer in
    my end. Advance thanks.

Posting Permissions

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