Page 1 of 1

UNIDAC show clob has erors in direct mode for oracle

Posted: Sun 19 Dec 2010 15:04
by 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.

Posted: Sun 19 Dec 2010 15:16
by daizhicun
the pic of demo:

Image

Posted: Mon 20 Dec 2010 09:18
by AlexP
Hello,

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

Posted: Mon 20 Dec 2010 13:23
by 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.

Posted: Mon 20 Dec 2010 13:40
by AlexP
Hello,

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

Posted: Mon 20 Dec 2010 16:11
by 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.

Posted: Thu 31 Mar 2011 14:42
by daizhicun
thanks , the new vision has fixed this bug

Posted: Mon 12 Mar 2012 21:37
by 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. :)
daizhicun wrote:thanks , the new vision has fixed this bug
Las Vegas hotel deals | List of Las Vegas hotels

Re: UNIDAC show clob has erors in direct mode for oracle

Posted: Fri 20 Feb 2015 14:47
by 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?

Re: UNIDAC show clob has erors in direct mode for oracle

Posted: Fri 20 Feb 2015 16:23
by 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.