* * *

Author Topic: [SOLVED] Problem with Oracle CLOB Field  (Read 2449 times)

fercosta80

  • New member
  • *
  • Posts: 17
[SOLVED] Problem with Oracle CLOB Field
« 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?
« Last Edit: October 12, 2016, 05:51:31 pm by fercosta80 »

LacaK

  • Hero Member
  • *****
  • Posts: 551
Re: Problem with Oracle CLOB Field
« Reply #1 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 ...

Hansvb

  • Sr. Member
  • ****
  • Posts: 331
Re: Problem with Oracle CLOB Field
« Reply #2 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.

miab3

  • Jr. Member
  • **
  • Posts: 94
Re: Problem with Oracle CLOB Field
« Reply #3 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

Hansvb

  • Sr. Member
  • ****
  • Posts: 331
Re: Problem with Oracle CLOB Field
« Reply #4 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.

Hansvb

  • Sr. Member
  • ****
  • Posts: 331
Re: Problem with Oracle CLOB Field
« Reply #5 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.
« Last Edit: August 25, 2016, 05:03:13 pm by Hansvb »

Hansvb

  • Sr. Member
  • ****
  • Posts: 331
Re: Problem with Oracle CLOB Field
« Reply #6 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?

fercosta80

  • New member
  • *
  • Posts: 17
Re: Problem with Oracle CLOB Field
« Reply #7 on: October 12, 2016, 05:48:50 pm »
Hi.

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

Hansvb

  • Sr. Member
  • ****
  • Posts: 331
Re: [SOLVED] Problem with Oracle CLOB Field
« Reply #8 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.

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus