| ORA-01400: cannot insert NULL into [message #238073] |
Wed, 16 May 2007 10:35  |
mkramer
Messages: 3
Registered: May 2007
Location: Missouri
|
Junior Member |
|
|
|
First off - I'm an extreme newbie to Oracle forms so please bear with me. I've created a screen that has 2 canvases. The main canvas where the user enters an id field and a stacked canvas that shows any existing data associated with the id field. The inquiry part works fine. However when I make a change to the data and try and save it I'm getting an "ORA-01400: cannot insert NULL into " and it references the key field (= the ID field entered). In my mind it's saying that I haven't populated the key field. I tried populating it in different triggers but nothing seems to make a difference. What am I missing?? Thanks for any help.
|
|
|
|
|
|
|
|
| Re: ORA-01400: cannot insert NULL into [message #239089 is a reply to message #238073] |
Mon, 21 May 2007 08:04  |
mkramer
Messages: 3
Registered: May 2007
Location: Missouri
|
Junior Member |
|
|
Thanks David for your input. Being a newbie I've tried several configurations trying to get this to work. I started off with just one canvas. Anyway someone else pointed out the fact that my key_block needed to be a non-database block. Once I changed that everything started working correctly.
Where is the 'tutorial exercise' located?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
