This discussion is archived
1 Reply Latest reply: Jan 16, 2013 6:24 AM by Jeff Smith SQLDev PM RSS

BLOB Value Replace and Built a String.

985232 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points