Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert a blank space in a not null field with Forms

388877Nov 10 2004 — edited Nov 10 2004

Hi all!

I know this will sound weird, but I have a NOT NULL field where I need to insert a blank space using Forms 9i.

I have managed managed to do it through a INSERT command in Oracle using but when I type space in the field in the forms, I get the error "cannot insert NULL into ...".

How does form manages inserts? Is is doing a trim of the field? Is it possible to insert a blank space in a not null field with forms or not?

Any help is welcome.
Tks!
Ariadne

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2004

Added on Nov 10 2004

#general-database-discussions

2 comments

409 views