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

Thread: Changing Standard Error Codes

  1. #1
    Join Date
    Feb 2000
    Posts
    24
    Is there anyway to change the error codes defined in the STANDARD package? ie: I'd like to reword the unique constraint violation description. Is this possible?

  2. #2
    Join Date
    Oct 2000
    Posts
    90
    You could trap them and then display whatever error you want.

  3. #3
    Join Date
    Feb 2000
    Posts
    24
    Can you give me a little direction on how to do that?

  4. #4
    Join Date
    Jun 2000
    Location
    Conway,AR,USA
    Posts
    29
    Try using INIT_PRAGMA
    I'm giving an example
    DECLARE
    deadlock_detected EXCEPTION;
    PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
    BEGIN
    ...
    EXCEPTION
    WHEN deadlock_detected THEN
    -- handle the error
    ...
    END;

    Soumya
    still learning

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