This content has been marked as final. Show 4 replies
The usage of to_date in line 9 is redundant as the variable already is a date.
Also you don't provide sufficient information as the procedure COMPLETo might modify vdate.
Senior Oracle DBA
have a look here
ORA-01830: date format picture ends before converting entire input string
Cause: A valid date format picture included extra data. The first part of the format picture was converted into a valid date, but the remaining data was not required.
Action: Check the specifications for date format pictures and correct the statement.
Edited by: Soli on 17.8.2009 10:02
Thanks to both of you, i have changed the datatype of vdate from date to varchar2 and its working.
i have changed the datatype of vdate from date to varchar2 and its working.Until it breaks when the contents are no longer any valid date!