Information générale
Titre:
Oracle ODBC Error ???
Hi
When using an updatable cursor in a form, and saving the changes I can sometimes get the following message :
* [ORACLE][ODBC]No data at executioon values pendig.
*
* Reverting changes in cursor
*
*
This message is followed by :
* Connectivity error: [ORACLE][ODBC][Ora] ORA-03127: no new
* operations allowed until the active operation ends.
The error is recreatable, after a number of updates going in and out of a form. There is no specific data that causes it, and the table it is going against does not have any BLOB fields.(Which is what most of my research is indicating can cause this error.) This is not for just one specific form/table, but going against a number of different once...
I am using
SQLEXEC( lnConHandle, lcSql, lcUpdtCursor)
and the following Cursorsetprop's
CURSORSETPROP("TABLES", lcTableName, lcUpdtCursor)
CURSORSETPROP("KEYFIELDLIST", lcKeyField, lcUpdtCursor)
CURSORSETPROP("UPDATABLEFIELDLIST", lcUpdFields, lcUpdtCursor)
CURSORSETPROP("UPDATENAMELIST", lcUpdNames, lcUpdtCursor)
CURSORSETPROP("WHERETYPE", 1, lcUpdtCursor)
CURSORSETPROP("SENDUPDATES", .T., lcUpdtCursor)
CURSORSETPROP("BUFFERING", 5, lcUpdtCursor)
and for commiting the changes ....
TABLEUPDATE(2, .F., lcUpdtCursor)
&& where lcUpdtCursor is the name of the cursor.
Do you have any soughts what could cause this, or what the solution would be???
Thank you Cicilia
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement