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 <[email protected]> > -----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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-developer > -- ----------------- Andrea Peri . . . . . . . . . qwerty àèìòù -----------------
_______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
