ORA-00932 error - inconsistent datatype

1 view

Skip to first unread message

Helpasap

unread,

Sep 21, 2006, 5:45:13 AM9/21/06

to ORACLE_DBA_EXPERTS

Select 'Datum teambespreking: '|| to_char(FIIN.antwoord,'dd - mm -
yyyy') From for_ingevuld FOIN , fit_ingevuld FIIN Where
FOIN.fin_nummer = FIIN.fin_nummer And FIIN.for_nummer=FOIN.for_nummer
And FOIN.koppeling =:par_beha And FOIN.revalidantcode =:par_reva
And FIIN.fin_nummer =:par_foin And FIIN.for_nummer = 344 And
FIIN.fit_nummer = 3490 And FOIN.soort_koppeling = 'B' And antwoord
is not null

The statement: Select FIIN.antwoord From ... etc... works correct.

What is the correct statement?

Jan

fitzj...@cox.net

unread,

Sep 21, 2006, 10:51:32 AM9/21/06

to ORACLE_DBA_EXPERTS

Obviously FIIN.andwoord is not a DATE column. Try NOT using the
to_char() function.