Problem dbms_output.get_line of Oracle 8i Direct Mode

[ysyang]

Hello,

I use ODAC 9.6.22 for Delphi 2009 and Oracle 8i and 9i
It had direct mode connect to Oracle 8.1.7 and Oracle 9i
My Code is below.

Code: Select all

       sSQL := 'begin  dbms_output.get_line(:LINE, :STATUS); end;';
        OutPutSQL := TOraSQL.Create(Self);
        OutPutSQL.Session := SQLSession;
        OutPutSQL.SQL.Text := sSQL;
        With OutPutSQL.ParamByName('STATUS') do
        begin
          DataType := ftFloat;
          ParamType := ptOutput;
          Value := 1;
        end;
        With OutPutSQL.ParamByName('LINE') do
        begin
          DataType := ftWideMemo;
          ParamType := ptOutput;
          Value := '';
        end;
        OutPutSQL.Execute;

This code is not a problem in Oracle 9i, there is a problem in Oracle 8i

Error message is below
"Unknow error 1."

How do i solve this problem?

[MaximG]

We have checked functioning of ODAC 9.6.22 for Delphi 2009 and Oracle 8i in Direct Mode using the DBMS_OUTPUT package. Unfortunately, we couldn't reproduced the "Unknow error 1." error according to your description. For further investigation of the issue, please send a complete project sample, which execution leads to this error, to maximg*devart*com