Skip to Main Content

i want to update date field in oracle table using database adaptor

662666Jan 15 2009 — edited Jan 15 2009
Hi Guys,

I want to update date in oracle table field which is 'DATE' type , but i am getting following error.

Pure SQL Exception.
Pure SQL Execute of update crp3apps.IFACE_SO_DATE_CHANGES set PROCESSED_DATE=? where CTRL_ID=? failed. Caused by java.sql.SQLException: ORA-01830: date format picture ends before converting entire input string
.
The Pure SQL option is for border use cases only and provides simple yet minimal functionality. Possibly try the "Perform an operation on a table" option instead.
</summary>
</part>
- <part name="detail">
<detail>
ORA-01830: date format picture ends before converting entire input string
</detail>


i am formated the date using following code and assigned to one variable.

ora:formatDate(ora:getCurrentDateTime(),'dd-MMM-yyyy hh:mm:ss ')


this is update query

update crp3apps.IFACE_SO_DATE_CHANGES set PROCESSED_DATE=#date where CTRL_ID=#id



Please provide solution.

regards
janardhan
Comments
Post Details
Added on Jan 15 2009
7 comments
4,515 views