cannot use keyset-driven cursor join?
Posted: Tue May 06, 2003 6:32 am
hi all,
i am using odbc method to fetch data from oracle.
i am using aggregate(min,max,ceil,nvl) function in my sql query.
if i use aggregate functions i am gettting the follwing error.
Warning: SQL error: [Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct clause, union, intersect or minus or on read only result set, SQL state S1C00 in SQLExecDirect in c:\apache\htdocs\strk.php on line 21
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in c:\apache\htdocs\strk.php on line 24
any one have any idea where i am wrong.
i am using odbc method to fetch data from oracle.
i am using aggregate(min,max,ceil,nvl) function in my sql query.
if i use aggregate functions i am gettting the follwing error.
Warning: SQL error: [Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct clause, union, intersect or minus or on read only result set, SQL state S1C00 in SQLExecDirect in c:\apache\htdocs\strk.php on line 21
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in c:\apache\htdocs\strk.php on line 24
any one have any idea where i am wrong.