Try:

insert into aodbab2k.employee_event
(EMPL_HR_ID, CHANGE_CD, CHANGE_TYPE, EFFECTIVE_DATE,
SEQUENCE_NUM, ASSORCL_POSTD_DATE)
values ('ZH81RHX', '1401', 'PAC',
to_date ('15-MAY-2001','DD-MON-YYYY'), 9,
to_date ('31-MAY-2001','DD-MON-YYYY'))

HTH,
~Dan.

-----Original Message-----
From: Dancy, Jerry A (Jerry)** CTR ** [mailto:[Email Address Removed] Thursday, May 31, 2001 12:38 PM
To: LazyDBA.com Discussion
Subject: Insert Error


I issued the following query and I was given the following error. I have
never encountered this error and the error manual is not much help. I dont
know anything about date format pictures. Any advice?

Thanks everyone

JAD



1 insert into aodbab2k.employee_event
2 (EMPL_HR_ID, CHANGE_CD, CHANGE_TYPE, EFFECTIVE_DATE,
3 SEQUENCE_NUM, ASSORCL_POSTD_DATE)
4* values ('ZH81RHX', '1401', 'PAC', '15-MAY-2001',9, '31-MAY-2001')
SHRT-AODBA> /
insert into aodbab2k.employee_event
*
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page