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 LazyDBA home page