General information
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only