Insert single space into NOT NULL field in FORMS

[stef1711]

Hi,

I have never try this but
BEGIN
:block_name.column_name := NVL(:block_name.column_name , chr(XX));
END;

with XX the ASCII code of the space character (sorry i don't remember if it is 32 or 20)

Let me know if it works