Scripting using oracle database and variables

Version 1
    This document was generated from CDN thread

    Created by: SharonSpencer (simulated) on 19-03-2009 11:00:45 PM
    HI,
     
     
    I'M USING THE DBWRITE STEP IN A SCRIPT TO UPDATE DATA IN AN ORACLE TABLE. i'M USING IPCC EXPRESS 4.1 AND ORACLE 10G. THE UPDATE IS SIMPLE, UPDATE "TABLE_NAME" SET "COLUMN_NAME" = ARIABLE1 WHERE "TABLE_COLUMN" = :A_VALUE; WHEN THE VALUES ARE HARDCODED THE PROCESS WORKS FINE, WHEN THE VALUES ARE PASSED AS A VARIABLE NOTHING IS CHANGED IN THE DATABASE.
     
    I'VE ALSO TRIED HARDCODING 1 AND THE SECOND IS A VARIABLE, IT SEEMS THAT WHEN A VARIABLE IS INVOLVED THE UPDATE DOES NOT WORK.
     
    ANY SUGGESTIONS.