I've upgraded to the current ezComponets. PersistentObject is at 1.6. I have some problems writing data back to the database. In some cases I get the following a stack trace, as that appended to the end of the mail. Oracle is complaining that for a given value for a numeric field is not numeric or a string not parseable as a string.
If I echo the query, as it in persistent_session.php:689, it is UPDATE "REQUISITION_ITEM" SET "RQI_QTY" = :ezcValue1, "ORP_ID" = :ezcValue2, "ORS_ID" = :ezcValue3 WHERE "RQI_ID" = :ezcValue4 and the content of ezcQuery::boundValues is ( [:ezcValue1] => 3 [:ezcValue2] => 25 [:ezcValue3] => 20 [:ezcValue4] => 41 ) The database table is CREATE TABLE "PLANTMAP"."REQUISITION_ITEM" ( "RQI_ID" NUMBER(*,0) NOT NULL ENABLE, "RQI_QTY" NUMBER NOT NULL ENABLE, "ORP_ID" NUMBER DEFAULT 40, "ORS_ID" NUMBER DEFAULT 20 NOT NULL ENABLE, .... ) As said before, for some of the load saves on other objects everything works fine. Can anybody give me some hint how diagnose the problem and fix it? Thanks, Peter Stack Trace: Jul 15 20:07:28 [Error] [default] [default] exception 'ezcPersistentQueryExcepti on' with message 'A query failed internally in Persistent Object: SQLSTATE[HY000 ]: General error: 1722 OCIStmtExecute: ORA-01722: invalid number (/root/PDO_OCI-1.0/oci_statement.c:142) Query: 'UPDATE "REQUISITION_ITEM&q uot; SET "RQI_QTY" = :ezcValue1, "ORP_ID" = :ezcValue2, &quo t;ORS_ID" = :ezcValue3 WHERE "RQI_ID" = :ezcValue4'' in /usr/shar e/pear/ezc/PersistentObject/persistent_session.php:712 Stack trace: #0 /usr/share/pear/ezc/PersistentObject/handlers/save_handler.php(378): ezcPersi stentSession->performQuery(Object(ezcQueryUpdate), true) #1 /usr/share/pear/ezc/PersistentObject/handlers/save_handler.php(107): ezcPersi stentSaveHandler->updateInternal(Object(R3PmRequisitionItem), false) #2 /usr/share/pear/ezc/PersistentObject/persistent_session.php(409): ezcPersiste ntSaveHandler->saveOrUpdate(Object(R3PmRequisitionItem)) #3 /data/sites/R3-PlantMap/sito/lib/r3_base.php(1440): ezcPersistentSession->sav eOrUpdate(Object(R3PmRequisitionItem)) #4 /data/sites/R3-PlantMap/sito/lib/r3_base.php(1538): R3BaseController->handleS tandardAct(Array, '41', Array) #5 /data/sites/R3-PlantMap/sito/web/admin/edit.php(55): R3BaseController->handle Req(Array) #6 /data/sites/R3-PlantMap/sito/web/admin/edit.php(201): submitForm('requisition _ite...', Array) #7 {main} -- Dott. Peter Hopfgartner R3 GIS Srl - GmbH Via Johann Kravogl-Str. 2 I-39012 Meran/Merano (BZ) Email: peter.hopfgart...@r3-gis.com Tel. : +39 0473 494949 Fax : +39 0473 069902 www : http://www.r3-gis.com -- Components mailing list Components@lists.ez.no http://lists.ez.no/mailman/listinfo/components