DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLSTATE: HY092, [Oracle][ODBC]Invalid attribute/option iden <0> on SQLSetPos() while SQL_DELETE

3281761Aug 30 2016 — edited Aug 30 2016

Hi,

I am working on ODBC3.0 C APIs, and using oracle database.

When I am trying to delete one particular row using SQLSetPos() method, it is failed to delete the row.

I have used SQL_CURSOR_KEYSET_DRIVEN cursor type.

Getting a following error on SQLSetPos(hstmt, 1, SQL_DELETE, SQL_LOCK_NO_CHANGE):

SQLSTATE: HY092, [Oracle][ODBC]Invalid attribute/option iden <0>.

According to sql forum, it says that operation or locktype might be invalid, but can not see any problem with SQLSetPos() method call.

What can be the problem with statement, operation and locktype?

Need Help!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2016

Added on Aug 30 2016

#odbc, #oracle, #windows-and-net

1 comment

846 views