Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Warsaw / Poland
    Posts
    73

    Unanswered: Exception handling

    Hello,

    Code:
    SQL> exec p;
    BEGIN p; END;
    
    *
    ERROR at line 1:
    ORA-01476: divisor is equal to zero
    ORA-06512: at "GRZEGORZ.P", line 7
    ORA-06512: at line 1
    When I call this proc in another, I can get -01476 with SQLCODE, description with SQLERRM(SQLCODE). But is it possible to retrieve ORA-06512: at "GRZEGORZ.P", line 7?

  2. #2
    Join Date
    Mar 2004
    Location
    Warsaw / Poland
    Posts
    73
    Hm, my version is 9i. In 10g it's possible as described in http://www.quest-pipelines.com/newsletter-v5/0904_A.htm. In this aritcle they claim that in oracle < 10g it isn't possible but I hope someone has some tricky workaround for that ;-)

Posting Permissions

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