PHP 4.0 Bug #9261 Updated: odbc to an oracle 'view' fails
| From: | bengt dot nilsson at aerotechtelub dot se | Date: | Thu, 15 Feb 2001 00:37:10 +0000 |
| Subject: | PHP 4.0 Bug #9261 Updated: odbc to an oracle 'view' fails | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-46614@lists.php.net to get a copy of this message | ||
ID: 9261
User Update by: bengt.nilsson@aerotechtelub.se
Status: Open
Bug Type: ODBC related
Description: odbc to an oracle 'view' fails
Hi,
I disabled "#define HAVE_SQL_EXTENDED_FETCH 1 " and that seems to do the thing.
/Bengt
Previous Comments:
---------------------------------------------------------------------------
[2001-02-14 14:26:15] bengt.nilsson@aerotechtelub.se
I've tried SQL_CUR_USE_ODBC, SQL_CUR_USE_IF_NEEDED, SQL_CUR_USE_DRIVER and SQL_CUR_DEFAULT with
the same result.
/Bengt
---------------------------------------------------------------------------
[2001-02-14 10:19:50] kara@php.net
You could try to pass SQL_CUR_USE_ODBC as additional
parameter to odbc_connect() and see if this helps.
---------------------------------------------------------------------------
[2001-02-14 09:54:19] bengt.nilsson@aerotechtelub.se
Hi,
I' running openlink to an oracle(8.1.5) server. When I try to do a 'select' from a
view I get the error from PHP:
"Warning: SQL error: [OpenLink][ODBC][Driver]No key columns found for table referenced by
keyset driven cursor., SQL state IM909 in SQLPrepare "
(Using the same driver from Perl works fine)
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=9261