Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Datatype mismatch ??

Re: Datatype mismatch ??

From: Galen Boyer <galenboyer_at_yahoo.com>
Date: 3 May 2001 21:13:21 -0500
Message-ID: <u3dalx3pd.fsf@primix.com>

On Fri, 04 May 2001, fredz_at_silversoftware.com wrote:

> insert into bom_dummy_ref_desgs from
> select * from bom_unique_ref_desgs
>
> I get an error stating: Datatype mismatch on field UPDATE_DATE
> of type Date.

Can you execute these in a sqlplus window and post the results?

desc bom_dummy_ref_desgs
desc bom_unique_ref_desgs

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.
Received on Thu May 03 2001 - 21:13:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US