I have a form where an item's value is being passed from another page."Item: P31_DATABASE_ID
inka wrote:Why do you mention this? This item won't change anything. You get an ora-1400, not 1403 or 1422. The item does not have source type "database column", so it won't be applied to the database when you're using the built in DML process.
Source type: SQL Query
Souce: select database_name from databases
where database_name = :P20_DATABASE_NAME"
When I click on the Create button I get this error:Do you use the apex DML process or do you use a PLSQL process you've created yourself? What table is the insert happening on? One of the columns of the record you are inserting is defined as "not null" on the database, and you are trying to put a "null" value into it. You'll have to check to see which column this is.
ORA -1400 cannot insert null into table .......