How do I 'null' a blob field in Forms 10g
937456May 15 2012 — edited May 15 2012I am using READ_IMAGE_FILE(...) to populate a blob on my 10g form with an image, but how to I delete it again (note - I do not want to delete the whole record, nor clear the whole block, as the user will have entered data in many other fields before reaching this point).
I've tried setting it to NULL and I've tried selecting empty_blob() from dual into this field, but forms will not let me do either (complaining: Bad Blind Variable).
I've also tried creating a image that is 0 by 0, then using READ_IMAGE_FILE(...) to populate it, but it considers it an invalid file.
There must be some way to clear a blob item in a Form.