Re: Avoiding ORA-01722 Invalid Number

In article <1118128611.853063.323020_at_f14g2000cwb.googlegroups.com>, says...
> <rant> i hate to see these 'fancy' solutions from so-called
> object-designers that cannot tell the difference between numeric
> datatypes and alphanumeric. Ever thought about using the correct
> datatype for what you want to do ? i.e. numbers for numbers, dates for
> dates etc. Pretty advanced concept i guess. </rant>
>
>

It is indeed an advanced concept! Problem is, sometimes you discover that there is a requirement which hadn't been considered at the outset....then you look for a workaround which can implemented without pain and quickly.

But your point is valid.

-- 

jeremy