da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: error with Tadquery and oracle clob

Forum List » AnyDAC » v 1.x General English

korntex5

User

Junior Boarder

Posts: 11

Karma: 0

error with Tadquery and oracle clob

Posted: 2007/08/31 01:09

Hi i test the tadcomponent, but when i open with my tadquery on a table with a clob oracle i have an error:
[AnyDAC][Phys][Ora][OCI] ORA-24806: non concordance entre les formes LOB.

my sql text is a simple 'select myclob from mytable where id=XXX'
i have an oracle 8 client
and i work on delphi 5

any solutions?

Diman

Admin

Posts: 1495

Karma: 19

Re:error with Tadquery and oracle clob

Posted: 2007/08/31 02:13

Hello

1) This is a bug in 1.12. To fix it, open daADPhysOraclWrapper.pas, find there method TOCILobLocator. There is a call of Lib.OCILobRead. Try to replace last parameter with SQLCS_IMPLICIT.
2) In 2.0 this will be fixed.

Regards,
Dmitry

korntex5

User

Junior Boarder

Posts: 11

Karma: 0

Re:error with Tadquery and oracle clob

Posted: 2007/08/31 08:59

thanks for your quick help it's work perfectly.
but the the re-compil of your component is not easy, or i don't understand.
have you a method to compil easyly.

Diman

Admin

Posts: 1495

Karma: 19

Re:error with Tadquery and oracle clob

Posted: 2007/08/31 09:07

Most simple - delete all daAD*.* from Delphi 5ProjectsBPL. Then open daADD5.bpg and recompile all packages. Then install daADDclD5.bpl.

Forum List » AnyDAC » v 1.x General English