[SOLVED] Problem with Oracle CLOB Field
lazarus / 16-Databases

----------------------------------------------------------------------
fercosta80 · 2016-08-22 22:10

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 · 2016-08-23 10:57

Quote from: fercosta80 on August 23, 2016, 12:10:05 am 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 · 2016-08-23 12:33

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 · 2016-08-23 19:05

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 · 2016-08-23 20:38

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

----------------------------------------------------------------------
Hansvb · 2016-08-25 14:56

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 · 2016-08-25 15:13

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 · 2016-10-12 15:48

Hi.

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

----------------------------------------------------------------------
Hansvb · 2017-06-28 19:12

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.