Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> GPF receiving 2 LONG's in a Join with SQLGetData

GPF receiving 2 LONG's in a Join with SQLGetData

From: Uwe Hoell <hoell_at_aaeb.de>
Date: Tue, 28 Dec 1999 12:19:31 +0100
Message-ID: <38689CC3.45B40F5B@aaeb.de>


My testcase is:
Oracle Server 8.0.5.1.1 (NT)
Net8 (TCP/IP-Protocolladapter) 8.0.5.0.0 Oracle-ODBC-Treiber 8.00.57.00 (the newest!)

create table t1 (i integer, l long);
create table t2 (i integer, l long);

insert into t1 (i) values ( 1);
insert into t2 (i) values ( 1);

The I try to retrieve data with MS-ODBCTest-Tool
(Odbcte32.exe) from query:

"select * from t1, t2 where t1.i=t2.i"

  1. FullConnect Menu: Conn->Full Connect
  2. enter selectstatement in StatementWindow select * from t1, t2 where t1.i=t2.i
  3. ExecDirekt Menu: Stmt->SQLExecDirect
  4. SQLFetch Menu: Results-SQLFetch
  5. SQLGetData Menu: Results->SQLGetata ColumnNumber: 1 returns: 1
  6. SQLGetData Menu: Results->SQLGetata ColumnNumber: 2 returns: NULL
  7. SQLGetData Menu: Results->SQLGetata ColumnNumber: 3

executing 7. I allways get a Windows GPF.

What could be the problem?
Can't the Oracle-ODBC-Driver handle 2 BLOBS in a row? I checked this out with different odbc32.dll-packages
(including that from Oracle).

(Same case with Merant-ODBC-Driver works fine!)

thanx!!!

--

Uwe Hoell                    Systemdesign
-----------------------------------------------------------
AEB GmbH                     
Julius-Hoelder-Str. 39       Tel. +49 711 7 28 42-300
D-70597 Stuttgart            Fax. +49 711 7 28 42-333
http://www.aeb.de/           eMail: hoell a aeb de
Received on Tue Dec 28 1999 - 05:19:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US