OraFAQ Forum: Forms » Removing an Image from Data Block

Home » Developer & Programmer » Forms » Removing an Image from Data Block (Forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Removing an Image from Data Block [message #454961]

Sun, 09 May 2010 00:50

ReuWekIa
Messages: 2
Registered: May 2010

Junior Member

Hi All,

While there's numerous QAs about inserting an image into the DB using the Data Block, how does one remove an image?

Obviously there's the "UPDATE ... SET X = EMPTY_BLOB();", however, that kills the Data Block/Form's flow, and it doesn't update.

I've tried a few things:
* :CONTROL.IMG1 := NULL; (bad bind variable)
* :CONTROL.IMG1 := EMPTY_BLOB(); (some other error, probably as above)

Any ideas?

Thanks,
Reu

Report message to a moderator