[Qgis-developer] Oracle: error inserting dates

[Andrea Peri]

Check the NLS of the connection.
If the connection don't declare an NLS , it will use the default NLS.
I guess the NLS in american or english and don't understand dd/mm/yyyy

A.



2014/1/15 Paolo Cavallini <cavallini at faunalia.it>

> -----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-----
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140115/d5b11ded/attachment-0001.html>