Hi all,
I'm using array DML feature when calling a stored proc with a TOracleQuery. I've declared one variable for each procedure's parameters and associated an array of variant with each variable (as explained in DOA manual) in my program. The stored procedure just make an insert or an update in a table.
Sometimes, Oracle raises an error (01400 : cannot insert null into ... or 01407 : cannot update to null...). This error never occurs on the same field. I've created a log file to write the values passed to the OracleQuery... and all values corresponding to the record are valid !
Any Idee ?
I'm using DOA 3.3.3 with D5 pro.
B.L.
I'm using array DML feature when calling a stored proc with a TOracleQuery. I've declared one variable for each procedure's parameters and associated an array of variant with each variable (as explained in DOA manual) in my program. The stored procedure just make an insert or an update in a table.
Sometimes, Oracle raises an error (01400 : cannot insert null into ... or 01407 : cannot update to null...). This error never occurs on the same field. I've created a log file to write the values passed to the OracleQuery... and all values corresponding to the record are valid !
Any Idee ?
I'm using DOA 3.3.3 with D5 pro.
B.L.
