Lazarus

Programming => Databases => Topic started by: fercosta80 on August 23, 2016, 12:10:05 am

Title: [SOLVED] Problem with Oracle CLOB Field
Post by: fercosta80 on August 23, 2016, 12:10:05 am
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?
Title: Re: Problem with Oracle CLOB Field
Post by: LacaK on August 23, 2016, 12:57:57 pm
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 ...
Title: Re: Problem with Oracle CLOB Field
Post by: Hansvb on August 23, 2016, 02:33:44 pm
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.
Title: Re: Problem with Oracle CLOB Field
Post by: miab3 on August 23, 2016, 09:05:10 pm
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
Title: Re: Problem with Oracle CLOB Field
Post by: Hansvb on August 23, 2016, 10:38:35 pm
Great. I am not able to try it now, but as soon as i can i will try this.
Title: Re: Problem with Oracle CLOB Field
Post by: Hansvb on August 25, 2016, 04:56:09 pm
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.
Title: Re: Problem with Oracle CLOB Field
Post by: Hansvb on August 25, 2016, 05:13:40 pm
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?
Title: Re: Problem with Oracle CLOB Field
Post by: fercosta80 on October 12, 2016, 05:48:50 pm
Hi.

Problem solved. I am using the ZeosDBO.
Thank you all.
Title: Re: [SOLVED] Problem with Oracle CLOB Field
Post by: Hansvb on June 28, 2017, 09:12:28 pm
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.
TinyPortal © 2005-2018