Strings with more than 2000 characters - problem

Hi.

I'm using Delphi 3 C/S version to access a Oracle DB. My problem is that I cannot get a long datatype updated if the string I wan't to update with exceeds 2000 characters.

The table is defined something like:.

Create Table MyTable
  ( MyTable_Id NUMBER,
....
....

    MyTableLongStr LONG );

and my sql is something like:
  with Query1 do
  begin
    SQL.Clear;
    SQL.Add(Format('Update MyTable set MyTableLongstr = ''%s'' where MyTable_Id = ''%s''',['a very long string .... longer than 2000 chr.',1]));

    Prepare;
    ExecSql;
  end;

I have read about bind variables, but I don't know what it is and how to use them in an application.

Please help.

/Hans

hans.rytter_at_dk.pwcglobal.com Received on Fri Jan 22 1999 - 08:29:14 CST