PL/SQL Question:exceptions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: PL/SQL Question:exceptions

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    PL/SQL Question:exceptions

    Does anybody know where I can find a list of exceptions? We have developers who have coded these exceptions but i cant figure out what these exceptions mean??

    thanks
    Jigar
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    tahiti.oracle.com

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    they are defined in the package SYS.STANDARD :

    Code:
    --***************** Predefined exceptions *****************
    
      CURSOR_ALREADY_OPEN exception;
        pragma EXCEPTION_INIT(CURSOR_ALREADY_OPEN, '-6511');
    
      DUP_VAL_ON_INDEX exception;
        pragma EXCEPTION_INIT(DUP_VAL_ON_INDEX, '-0001');
    
      TIMEOUT_ON_RESOURCE exception;
        pragma EXCEPTION_INIT(TIMEOUT_ON_RESOURCE, '-0051');
    
    ...
    Orca


  4. #4
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Pando,
    can you pls be more specific?

    thanks
    "High Salaries = Happiness = Project Success."

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