Help with CONSTRAINTs in Oracle

From: Jannie de Beer GID SSG <debj0113_at_sasoldns>
Date: 31 Dec 1994 12:10:54 GMT
Message-ID: <3e3hoe$4ps_at_hermes.is.co.za>


Hi.
I am currently involved in converting an inhouse Sybase system to Oracle 7. But I have a problem with the way that Oracle seems to handle the CONSTAINT clause. When I declare a constaint in my Sybase system on a column or table, Sybase gives me the possibility to bind or link an error message to that constraint. As that constraint is violated Sybase then responds with a meaningfull error message.

I cannot find a way to bind a meaningfull error message to a constraint in Oracle. This is esspesialy a problem when more than one constraint are linked to a table and it's columns, as the user doen't know which constraint was violated and produced the error.

Thanks in advance for any help.

Jannie dB Received on Sat Dec 31 1994 - 13:10:54 CET

Original text of this message