Hi,
This error indicates that there is no index/primary key in a result set that
the driver is attempting to read into a cursor.
Adding a primary key to the table will fix this, or passing a different
cursor type in will fix this - keyset driven cursors are essentially
'sliding windows' - they read a set of rows in, and then scroll back and
forth. Upon reaching the end of the set, they grab the next keyset in the
direction of scroll.
On a related note, does anyone know to pass different cursor models in the
select statement? There are essentially 5 cursor models supported by SQL,
Static, Keyset, Mixed, Forward Scrollable, Bi-Directional Scrollable.
PHP's cursor handling has always been a bit of a mystery to me - if anyone
can point me towards the current implementation of it I will dig.
Best regards,
Andrew
--------------------------------------
Andrew Hill - OpenLink Software
Director Technology Evangelism
eBusiness Infrastructure Technology
http://www.openlinksw.com
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 14, 2001 9:54 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DEV] PHP 4.0 Bug #9261: odbc to an oracle 'view' fails
>
>
> From: [EMAIL PROTECTED]
> Operating system: RedHat Linux 6.1
> PHP version: 4.0.4pl1
> PHP Bug Type: ODBC related
> Bug description: odbc to an oracle 'view' fails
>
> 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)
>
>
>
>
> --
> Edit Bug report at: http://bugs.php.net/?id=9261&edit=1
>
>
>
> --
> PHP Development Mailing List <http://www.php.net/>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
