Bug report #19259

QGIS 3. Oracle error while adding features - ORA-01861

Added by Marcin Lis over 5 years ago. Updated about 5 years ago.

Assignee:Jürgen Fischer
Category:Data Provider/Oracle
Affected QGIS version:3.2 Regression?:Yes
Operating System:Win 7 Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:27087


When I add(edit) feature to layer with date field in oracle DB, I get this error:

Could not commit changes to layer WGK_SPRZATANIE
Errors: ERROR: 1 feature(s) not added.
Provider errors:
Oracle error while adding features: Oracle error: Could not insert feature -2
SQL: ORA-01861: literal does not match format string
Unable to execute statement

In Qgis 2.18.21 it's ok


#1 Updated by Maxime Resibois about 5 years ago

I had this issue too. Apparently it's a problem with the date format columns.

#2 Updated by dany Lefeuvre about 5 years ago

I have the same problem. I confirm this is the date insertion that creates this error.
Last test on QGIS 3.4.1

Also available in: Atom PDF