php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #9261 odbc to an oracle 'view' fails
Submitted: 2001-02-14 09:54 UTC Modified: 2001-07-03 04:52 UTC
From: bengt dot nilsson at aerotechtelub dot se Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.4pl1 OS: RedHat Linux 6.1
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2001-02-14 09:54 UTC] bengt dot nilsson at aerotechtelub dot 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)

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-02-14 10:19 UTC] 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 14:26 UTC] bengt dot nilsson at aerotechtelub dot 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 19:37 UTC] bengt dot nilsson at aerotechtelub dot se 
Hi,

I disabled "#define HAVE_SQL_EXTENDED_FETCH 1 " and that seems to do the thing.

/Bengt
 [2001-06-08 15:54 UTC] kalowsky@php.net 
from where did you remove the HAVE_SQL_EXTENDED_FETCH define?
 [2001-07-03 04:52 UTC] derick@php.net 
No feedback
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Apr 25 21:01:36 2024 UTC