sudah ketemu, ternyata itu masalah di fungsi to_date() yang diisi character,
karena data yang diisi oleh sqlloader sedikit bermasalah.
coba aja, select to_date('a120504','DDMMYY') from dual;
CMIIW.
On 2/19/07, Tomi Wijanto <[EMAIL PROTECTED]> wrote:
>
> Mungkin bisa disertakan script dari view
> VIEW_LOADER_ACCEPT_ASCII.
> Sepertinya kejadian dibawah tidak mungkin terjadi pada
> table.
>
> regards,
> tomi
>
>
> --- indra syafruddin <[EMAIL PROTECTED] <indra.e00%40gmail.com>> wrote:
>
> > Saya coba jalanin query :
> >
> > "SELECT * FROM "SMSAPP2".VIEW_LOADER_ACCEPT_ASCII s
> > where to_char(s.END_TIME, 'DD-MM-YYYY') like
> > '14-02-2007'
> > and s.NODE_ID = 'combdg01' "
> >
> >
> > tapi muncul error ORA-01858: a non-numeric character
> > was found where a
> > numeric was expected
> >
> >
> > tetapi, jika saya ganti NODE_ID nya, data bisa
> > dimunculkan :
> >
> > SELECT * FROM "SMSAPP2".VIEW_LOADER_ACCEPT_ASCII s
> > where to_char(s.END_TIME, 'DD-MM-YYYY') like
> > '14-02-2007'
> > and s.NODE_ID = 'combjm01'
> >
> > Ada yang bisa bantu cari solusinya?
> > Data loader diambil menggunakan sqlloader.
> >
> > Terima kasih sebelumnya.
> >
>
> __________________________________________________________
> Need Mail bonding?
> Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
> http://answers.yahoo.com/dir/?link=list&sid=396546091
>
>
>
[Non-text portions of this message have been removed]
