RE: [PHP-DEV] PHP 4.0 Bug #9261: odbc to an oracle 'view' fails

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: bengt.nilsson@aerotechtelub.se > [mailto:bengt.nilsson@aerotechtelub.se] > Sent: Wednesday, February 14, 2001 9:54 AM > To: php-dev@lists.php.net > Subject: [PHP-DEV] PHP 4.0 Bug #9261: odbc to an oracle 'view' fails > > > From: bengt.nilsson@aerotechtelub.se > 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: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >