UNIDAC show clob has erors in direct mode for oracle

[daizhicun]

now i use the new version of unidac;

this bug were found half a year ago.
i waiting the new version and hope it can solve it.
but new version can't too.


for example;

the sql is:

BEGIN
v_clob := 'ss';
v_clob := v_clob || v_clob;
v_clob := v_clob || v_clob;
v_clob := v_clob || v_clob;
v_clob := v_clob || v_clob;
v_clob := v_clob || v_clob;
v_clob := v_clob || v_clob;
:SCRIPT := v_clob;
END;


the delph code is:

begin
uniQuery1.sql.text:=memo1.text;
uniQuery1.parambyname('SCRIPT').DateType :=ftOraClob;
uniQuery1.execute;
memo2.text:=uniQuery1.parambyname('SCRIPT').value;
end;

in oci mode:
memo2.text:='sss....ss';
in direct mode:
memo2.text:='sss....ss? ';


but this bug is sometimes show ,not every time show;

so we must test and test.

[daizhicun]

the pic of demo:

[AlexP]

Hello,

Thank you for the information.
We have reproduced the problem.
We will notify you as soon as we have any results.

[daizhicun]

thank you very much.

when you fiex it ;

please gvie me the fixed pas files and tell me where been updated .
it you can't gie .pas ,or give me .dcu


i help you test.

[AlexP]

Hello,

We will notify you as soon as we fix the bug, and we will send you the required file

[daizhicun]

thanks .
i use delphi more then ten years.
now i use delphi2010 ;
and l like reseach database :oracle,sqlserver,mysql,sqlite,etc.

UniDAC is the best privode for database in delphi;

can i join Devart Team ;And popularize it in China.

Let lots delphi user UniDAC instead of ADO,DbExpress,etc.

[daizhicun]

thanks , the new vision has fixed this bug

[evanjones246]

+1... I tried to work through this a few months ago, and could not figure it out with the bug. I put it off until you guys figured it out, and I just realized that it has been fixed! thanks for getting this error cleared.

thanks , the new vision has fixed this bug

Las Vegas hotel deals | List of Las Vegas hotels

[JeanR]

Hi, i do have this issue within the 4.1 version (not the latest one as i didn't renewed my license yet), however it should be fixed in this release isn't it ?

Using unicad 4.1 in delphi, with an Oracle 11 database, using the OCI mode everything is fine, using the DIRECT mode i can't update CLOB fields without receiving a ORA-01460 error. Any clue?

[AlexP]

You are using an obsolete UniDAC version, please try to reproduce the problem on the latest trial UniDAC version 6.0.2 http://www.devart.com/unidac/download.html , and if the problem repeats, contact us again.