You can build an SQL string that utilizes Oracle's DECLARE function:

   DECLARE new_text LONG;

   BEGIN
      new_text := '$ScalerWithNewValue';

      UPDATE YourDB.YourTable
      SET YourColumn = new_text
   END;
[download]

Then pass the SQL string through your DB interface.


Chris
'You can't get there from here.'