1 Reply Latest reply: Jan 16, 2013 8:24 AM by Jeff Smith Sqldev Pm-Oracle RSS

    BLOB Value Replace and Built a String.

    985232
      Hi,

      I have a blob value passed to my procedure and I need to find a value in the blob and replace with a different value and then convert the entire string to BLOB and then insert this value to a table.

      Ex: BLOB_String = 'ATRTYOFPTE9TYTUTUTUOE9TY'

      Procedure Convert_blob(BLOB_String BLOB)
      (
      Con_BLOB_String BLOB

      -- Read the Blob_String and check for '9' and replace with '-1'
      Con_BLOB_String := to_blob( 'ATRTYOFPTE-1TYTUTUTUOE-1TY')

      -- Insert the Value to the table
      Insert Into Blob values(Con_BLOB_String);

      )

      Thanks in advance
      Sam