Re: How to get back useful error messages?

From: Marcos Andres Vera Yañez <mvera_at_rdc.cl>
Date: Tue, 15 Sep 1998 09:24:37 -0500
Message-ID: <35FE78A5.6B1E71D@rdc.cl>

Hi
About your question on Oracle Group :
Look, there is a special command names "desc", you can see the columns description for a table, for example : desc customer. Try it ! Hope this help you.

Roy Smith wrote:

> I've got a table with a variety of constraints. I'm building a data-entry
> app, and want to be able to pass back to the user useful diagnostics about
> why an operation failed. The problem is, Oracle doesn't give particularly
> useful error messages. For example, if I deliberately cause an error:
>
> SQL> insert into person (alias) values ('roy.smith');
> insert into person (alias) values ('roy.smith')
> *
> ERROR at line 1:
> ORA-01400: mandatory (NOT NULL) column is missing or NULL during insert
>
> How do I know which of the several NOT NULL columns caused the problem?
>
> --
> Roy Smith <roy_at_popmail.med.nyu.edu>
> New York University School of Medicine
>

--

---

Marcos Vera Yanez
Oracle Database Adminstrator
Email : mvera_at_rdc.cl, Phone : 56-2-4406953

"Smell the Flower While you can"

---

Received on Tue Sep 15 1998 - 09:24:37 CDT