iteral does not match format string

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
satyame171
Participant
Posts: 13
Joined: Tue May 09, 2006 2:19 am

iteral does not match format string

Post by satyame171 »

hi to all,


This is satheesh. when i am running the sequence job i am geeting this error in server job log ORA-01861: literal does not match format string.

if anybody know please give me answer.


thanks,
satheesh
Last edited by satyame171 on Fri Jun 09, 2006 4:58 am, edited 1 time in total.
satheesh
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Re: iteral does not match format string

Post by balajisr »

satyame171 wrote:hi to all,


This is satheesh. when i am running the sequence job i am geeting this error in server job log ORA-01861: literal does not match format string.

if anybody know please give me answer.


thanks,
satheesh
Check your query. Literal used in functions such as to_date,to_char should match with the format string. Otherwise you get this error.
Post Reply