Hi,
I'm having a problem with SQLPrepare throwing an error the code is:
SQLRETURN ret = SQLPrepare(m_stmt, (SQLCHAR *)stmt,
(SQLINTEGER)strlen(stmt));
The stmt variable contains "SELECT COUNT(*) FROM nuance.ndb__mmp WHERE nuance_key = ?"
I get the following error:
SQL_ERROR - [SAP AG][SQLOD32 DLL][SAP DB]General error;-7008
POS(100) Updates of this table not allowed. (errcode -7008, sql state "S1000")
The sap db trace shows this:
STMMODE : ORACLE
SELECT COUNT(*) FROM nuance.ndb__mmp WHERE nuance_key = ? FOR UPDATE OF
PARSE : CMD :
SQLCODE: -7008 Updates of this table not allowed
PARSEID: OUTPUT: 00000000 00000000 00000000 00000000
SQLERRD(INDEX_6) : 63 ERROR NEAR ^ : Y = ? FOR ^UPDATE OF
START : DATE : 2002-10-30 TIME : 0011:56:27
END : DATE : 2002-10-30 TIME : 0011:56:27
DECLARE "SQL_CURSOR_0001" CURSOR FOR SELECT COUNT(*) FROM nuance.ndb__mmp WHERE
nuance_key = ? FOR UPDATE OF
PARSE : CMD :
SQLCODE: -7008 Updates of this table not allowed
PARSEID: OUTPUT: 00000000 00000000 00000000 00000000
SQLERRD(INDEX_6) : 100 ERROR NEAR ^ : Y = ? FOR ^UPDATE OF
START : DATE : 2002-10-30 TIME : 0011:56:27
END : DATE : 2002-10-30 TIME : 0011:56:27
What's wrong here?
Regards,
Ajit
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
