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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: bengt dot nilsson at aerotechtelub dot se
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Wed May 07 01:01:28 2025 UTC