[Qgis-developer] Oracle: error inserting dates

[Paolo Cavallini]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all.
I have been reported some errors in Oracle data entry. Apparently it is impossible to
insert data in DATE field, as follows:

=====================
"Impossibile applicare le modifiche al vettore ZONA_RECUPERO

Errori: ERRORE: 1 geometria non aggiunta.

  Errori della sorgente dati:
      Errore Oracle nell'aggiunta di geometrie:Errore Oracle: Impossibile inserire
geometria -2
    SQL: ORA-01843: not a valid month
    Impossibile eseguire l'istruzione
    Errore: INSERT INTO
"QGIS_TEST"."ZONA_RECUPERO"("SHAPE","VINCSIDE","VINCSCODTI","CODTIPCART","VINSSUPERF","LEGIDESTAR","VINCSDATAI","VINCSDATAF","LEGIDESTOP","GEOLINK")
VALUES (:f,'23005869',NULL,NULL,NULL,NULL,'10/04/2014','10/12/2999',NULL,NULL) "
=====================

I cannot access an Oracle db, so the question is: is this supposed to work? Does
somebody use it successfully?

All the best.
- -- 
Paolo Cavallini - www.faunalia.eu
Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iEYEARECAAYFAlLWtjoACgkQ/NedwLUzIr7XcwCfezjaJKadZ24eGYLFKR1vX1Hy
ZQwAn3wyjaORXDA6UHKfbb5Oq4n34KXd
=s9+t
-----END PGP SIGNATURE-----