Re: User-defined Error Messages ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 28 Mar 2001 21:02:16 +0200
Message-ID: <tc4d5ud0do4uc7@beta-news.demon.nl>

Raise application error(<any number below -20000, so -20001 etc>, Your message)

Hth,

Sybrand Bakker, Oracle DBA

  "Ray Vonhollen" <RVONHOLLEN_at_pacbell.net> wrote in message news:3AC22D97.13862425_at_pacbell.net...
  Can anyone give me the syntactical representation of how to define a User-defined Error Message? I do understand that Return Codes between 0 and 99999 are not reserved. SQL usually uses the RAISERROR() function. As an example I want to inform a User via a Trigger that a Record is in Use.
  Thanks in advance.

--

Received on Wed Mar 28 2001 - 13:02:16 CST