[SOLVED] Problem with Oracle CLOB Field

[fercosta80]

Hi.
I'm using TOracleConnection to connect to an Oracle DB 11. I'm trying to make a select on a table with CLOB field, but is not working. The Lazarus freezes when trying to run select . Fields BLOB or CLOB are supported by TOracleConnection?

[LacaK]

Fields BLOB or CLOB are supported by TOracleConnection?

Yes , at least partial support is there.
But AFAIK there is no routine testing with Oracle so there may be some problems ...

[Hansvb]

A few months ago i tried to select oracle geometry field with sqldb and zeos query. Both let lazarus crash. So if you find a way to select clob or blob fields i would like to know it.

[miab3]

Current
ZEOS 7.2.x svn 3929
http://sourceforge.net/p/zeoslib/code-0/HEAD/tree/branches/testing-7.2/
and
Zeos 7.3-beta branches_ testing_Revision svn 3918(3929):
http://sourceforge.net/p/zeoslib/code-0/HEAD/tree/branches/testing-7.3/
deal with ORACLE clob

Michal

[Hansvb]

Great. I am not able to try it now, but as soon as i can i will try this.

[Hansvb]

i got the trunc version of zeos 7.3. It does not compile with lazarus 1.6 (32 bit).

the  error message is: ZPlainDriver.pas(268,35) Error: Identifier not found "ZOSCodePage"

to early.
It works, i compiled the packages in the wrong order.

[Hansvb]

i do not have a clob or blob field but i have a geometry field in Oracle. Zoes 7.3 still does not like these fields.

the error is:
OCI_ERROR: ORA-22307: operation must be on a user-defined type

are there plans to implement this in ZEOS?

[fercosta80]

Hi.

Problem solved. I am using the ZeosDBO.
Thank you all.

[Hansvb]

How did you solve it? I still get the error "operation must be on a user-defined type" when i select an Oracle geometry field.