I have two users who are getting the error "ORA-01830: date format picture ends before converting entire input string." This is happening on both a HP9000 and HP Itanium using both Oracle 8 and 9. Looking at the output from the precompiler, the code looks correct. My only assumption is that the strings comprising the date format are being corrupted. Can you think of anything else?
The ORA-1830 error is thrown when the data being converted to a date datatype contains extra characters not shown in the date format. As an example, look at the following TO_DATE function call:
TO_DATE('12/13/2005 13:43:56','MM/DD/YYYY HH24:MI')
In the example above, I have the month, the date, the year, the hour, the minutes and the seconds. But the seconds are not included in the date format mask, 'MM/DD/YYYY HH:24:MI.' This format mask is shorter than the given value. So Oracle is telling you that this format picture ends before the entire input string has been converted to the DATE datatype. Double check your format mask and the value being applied to this format mask. You probably have extra characters there. Some characters, such as the tab character, may be invisible, so you might want to check the ASCII code of the value to ensure that there are not hidden characters.
Dig Deeper on Oracle database design and architecture