Why am I getting a write limit of 255 records on Oracle 10g using DBExpress?
I hit a brick wall during normal SQL processing
When connecting to Oracle 10g from a remote client with DBEXPRESS using the standard dbxpora.dll + oci.dll file
When in a transaction, after exactly 255 records, the connection hangs for 30 seconds and returns an error:
ORA-03114 (as if it lost connection ...)
This occurs when 255 records are inserted into any table during a transaction. (when run locally in db block everything works fine)
Is there something I am missing?
a source to share
Well, I don't know Oracle databases specifically, but I do know that 255 is a magic number. This is the maximum value you can express in one byte. Maybe something is declared as a byte counting your records and you are overflowing. Try rebuilding your whole project with range checking and overflow checking, and see if it throws any exception somewhere when you try it. This should help keep track of it if it is actually in the code you are compiling. If it's in one of the libraries it won't help.
a source to share