Re: Which column caused ORA-01438?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 01 Jun 2004 22:35:06 -0700
Message-ID: <1086154514.727990@yasure>

Noel wrote:

>>>I need to know because I'd like to return a meaningful error message,
>>>and I'd like to rely on check constraints as much as possible to
>>>implement these types of business rules.
>>
>>A meaningful error message? What king of weirdo are you?  ;-)

>
>
> Hello Daniel.
> It is meaningful, while table containts hundreds[1] of columns and
> one of it is 'to short'.
> Its horrible to find which one.
> --
> TomekB
>
> [1] Once i got that error on a table with 303 columns.
> It was not me who designed that monster.
> That person should be shot/hung/poisoned ;-)

You've got to be kidding. The only thing horrible is a table with 303 columns. If I ever saw that from one of my students ... they'd fail. From an employee ... they'd be assigned to work on their resume.

There is absolutely no excuse for a table with 303 columns.

Well there may be one or two good excuses. But in 35+ years in IT I've yet to see it.

Fix the real problem ... make your schema relational.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed Jun 02 2004 - 00:35:06 CDT