Re: Constraint error checking inraccle

In article: <3leq8b$fp3_at_horizon.synon.com> rnv_at_synon.com (Raghunath Valluri) writes:
>
>
> Does anyone know how Oracle reports constraint violations to
> ESQL programs. If for instance the constraint that is
> violated is not on the table on which the SQL was executed,
> how would an application designer wantting to do appropriate
> error handling know which constraint was violated.

The constraint errors issued by Oracle contain the name of the actual constraint that's been violated. Use the data dictionary or, better, a lookup table to interpret and use the constraint names and maybe put out a more meaningful message that's specific to the constraint.

-Tony. Received on Thu Mar 30 1995 - 00:00:00 CEST