Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ODBC update where current of cursor?

ODBC update where current of cursor?

From: Guy Rouillier <guyr_at_raleigh.ibm.com>
Date: 1998/03/23
Message-ID: <3516d34d.23900567@rtpnews.raleigh.ibm.com>#1/1

I'm trying to do a positioned update, and no matter how I arrange my statements, the Oracle ODBC driver keeps returning "SQL State: 34000 Message: [Oracle][ODBC Oracle Driver]Invalid cursor name." I'm using SQLSetCursorName() prior to executing the SELECT statement, and I've tried SQLPrepare() of the UPDATE statement both before and after SQLExecute() of the prepared SELECT statement. Regardless, SQLPrepare() of the UPDATE WHERE CURRENT OF gives the above error. How does one do a positioned update in Oracle using ODBC? Oracle 7.3.2.2 on Windows NT 4.0, using the latest Oracle ODBC driver. Thanks. Received on Mon Mar 23 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US