Trolltech Home | Qt-interest Home | Recent Threads | All Threads | Author | Date
All threads index page 7

Qt-interest Archive, March 2002
Large objects of Oracle

• Subject: Large objects of Oracle
• From: Martin Wilmes <martin.wilmes@xxxxxx>
• Date: Tue, 19 Mar 2002 12:46:15 +0100
• Sender: martin.wilmes@xxxxxx
• To: qt-interest@xxxxxxxxxxxxx

Hi,

how do I access large objects of oracle databases?

I tried to use the designer to build a QDataTable that shows a database table 
with columns of type CLOB. When starting the program it prints out 

"QOCIResult::cacheNext: ORA-00932: inconsistent datatypes"

and the QDataTable shows nothing!

I guess that it comes from the column of type CLOB, but I'm not shure about 
that.

Regards,
Martin

-- 
 [ signature omitted ] 

• Subject: Re: Large objects of Oracle
• From: Harald Fernengel <harald@xxxxxxxxxxxxx>
• Date: Tue, 19 Mar 2002 13:55:42 +0100
• To: martin.wilmes@xxxxxx, qt-interest@xxxxxxxxxxxxx

Hi,

> how do I access large objects of oracle databases?
> I tried to use the designer to build a QDataTable that shows a database
> table with columns of type CLOB. When starting the program it prints out
>
> "QOCIResult::cacheNext: ORA-00932: inconsistent datatypes"

Please update to Qt 3.0.3, this issue has been fixed there for Oracle 8 and 9.

Oracle 8 doesn't support field binding to BLOBs, you have to compile the QOCI8 
Plugin using the Oracle 9 client libraries or use the new plugin from Qt 
3.0.3 (which also works with Oracle 8).

Best regards,
Harald