UNIDAC show clob has erors in direct mode for oracle
Posted: Sun 19 Dec 2010 15:04
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.
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.