APEX

I have been developing a form for creating and updating Referral records. So far, I have been able to resolve all the issues I have run up against in figuring out how to create the form and fields.

Currently use the AUTO ROW PROCESSING to create new Referral records, and to edit existing ones. Creation of new records works just fine.

However when I attempt to edit an existing record and SAVE the changes, I get "ORA-01407: cannot update ("TTHUMB"."WISER_REFERRAL"."CREATE_DT") to NULL" and "Error Unable to process row of table WISER_REFERRAL" error messages.

It is showing as choking on updating the 'create_dt' field which is set up as a Hidden field, as is the 'created_by' field. When I look at the Session State information after the attempted SAVE, I do not see any values in the form field ('P205_CREATE_DT') for 'create_dt', however I do see the expected information in the 'P205_CREATED_BY' form field for the 'created_by' record field.

In looking at the Item definition for each of these two fields in the Page Definition, they appear to be defined exactly the same (unless I keep missing something when I look at them). Because the 'P205_CREATE_DT' session state item does not have the previous info from the record being updated, the DB is disallowing the record update as that would set a NOT NULL field to NULL.

I can upload a copy of the app to an APEX workspace (I created it last night in case it was needed) if that would help (and someone explains how to upload).

I have looked throughout the forum, and am unable to find a solution to this problem. Can anyone point me in the right direction???


Thank you.


My table being updated is defined as follows:

CREATE TABLE wiser_referral
( wr_id NUMBER(10,0) NOT NULL,
wiser_id NUMBER(10,0) NOT NULL,
status_cd CHAR(1) NOT NULL,
ref_type CHAR(1) NOT NULL,
ref_prior_interven_flg CHAR(1) DEFAULT 'N' NOT NULL,
ref_received_dt DATE NOT NULL,
ref_refr_by_person_type CHAR(2) NOT NULL,
ref_form_dt DATE,
ref_recd_by_id NUMBER(10,0),
ref_refr_by_full_name VARCHAR2(36),
ref_asmnt_plan_needed_flg CHAR(1) DEFAULT 'N' NOT NULL,
ref_declined_dt DATE,
ref_declined_reason VARCHAR2(1000),
ref_declined_by_id NUMBER(10,0),
ref_comments VARCHAR2(1000),
create_dt TIMESTAMP NOT NULL,
created_by VARCHAR2(30) NOT NULL,
update_dt TIMESTAMP,
updated_by VARCHAR2(30),
CONSTRAINT wiser_wr_id_pk PRIMARY KEY (wr_id) ENABLE,
CONSTRAINT CK_ref_prior_interven_flg CHECK (ref_prior_interven_flg IN ('Y','N')) ENABLE,
CONSTRAINT CK_ref_asmnt_plan_needed_flg CHECK (ref_asmnt_plan_needed_flg IN ('Y','N')) ENABLE
);


The following is the Session State information:

Page Items
App Page Item Name Display Item Value Status

123 205 P205_ACCEPT Button
123 205 P205_CREATE_DT Hidden R
123 205 P205_WR_ID Hidden 21 I
123 205 P205_WISER_ID Hidden 1 I
123 205 P205_STATUS_CD Select List I I
123 205 P205_REF_TYPE Select List A I
123 205 P205_REF_PRIOR_INTERVEN_FLG Checkbox N U
123 205 P205_REF_RECEIVED_DT Date Picker (MM/DD/YYYY) 06/05/2006 I
123 205 P205_REF_REFR_BY_PERSON_TYPE Select List 30 I
123 205 P205_REF_FORM_DT Date Picker (MM/DD/YYYY) 06/12/2006 I
123 205 P205_REF_RECD_BY_ID Text Field R
123 205 P205_REF_REFR_BY_FULL_NAME Text Field Thomas Toe I
123 205 P205_REF_ASMNT_PLAN_NEEDED_FLG Checkbox Y I
123 205 P205_REF_DECLINED_DT Date Picker (MM/DD/YYYY) R
123 205 P205_REF_DECLINED_REASON Textarea R
123 205 P205_REF_DECLINED_BY_ID Text Field R
123 205 P205_REF_COMMENTS Textarea XXX marks the spot. I
123 205 P205_DECLINE Button
123 205 P205_UPDATE_DT Hidden 20-JUN-06 U
123 205 P205_CREATED_BY Hidden Thomas Thumb (XX22) I
123 205 P205_UPDATED_BY Hidden Thomas Thumb (XX22) U

Application Items
no data found

Session State
App Page Item Name Display Item Value Label

123 0 P0_FORMATTED_EMP_NAME Hidden Thomas Thumb (XX22)
123 1 P1_ENTERED Text Field (always submits page when Enter pressed) Entered
123 1 P1_SCHOOL Text Field (always submits page when Enter pressed) School
123 1 P1_SELECTED_STU_ID Hidden 228670
123 1 P1_SELECTED_STU_WISER_ID Hidden 1
123 1 P1_STU_ID Text Field (always submits page when Enter pressed) 228670 Stu Id
123 1 P1_STU_NAME Text Field (always submits page when Enter pressed) Last Name
123 1 P1_WISER_ID Hidden WISER ID
123 1 P1_WISER_STATUS Text Field (always submits page when Enter pressed) WISER Status
123 35 P35_SELECTED_REFERRAL_ID Hidden
123 205 P205_CREATED_BY Hidden Thomas Thumb (XX22)
123 205 P205_CREATE_DT Hidden
123 205 P205_REF_ASMNT_PLAN_NEEDED_FLG Checkbox Y Assessment Plan Needed
123 205 P205_REF_COMMENTS Textarea XXX marks the spot. Comments
123 205 P205_REF_DECLINED_BY_ID Text Field Declined By Whom
123 205 P205_REF_DECLINED_DT Date Picker (MM/DD/YYYY) Declined Date
123 205 P205_REF_DECLINED_REASON Textarea Declined Reason
123 205 P205_REF_FORM_DT Date Picker (MM/DD/YYYY) 06/12/2006 Referral Form Date
123 205 P205_REF_PRIOR_INTERVEN_FLG Checkbox N Prior Intervention
123 205 P205_REF_RECD_BY_ID Text Field Rec'd By Whom
123 205 P205_REF_RECEIVED_DT Date Picker (MM/DD/YYYY) 06/05/2006 Referral Rec'd Date
123 205 P205_REF_REFR_BY_FULL_NAME Text Field Thomas Toe Full Name
123 205 P205_REF_REFR_BY_PERSON_TYPE Select List 30 Referred By Whom
123 205 P205_REF_TYPE Select List A Referral Type
123 205 P205_STATUS_CD Select List I Status Cd
123 205 P205_UPDATED_BY Hidden Thomas Thumb (XX22)
123 205 P205_UPDATE_DT Hidden 20-JUN-06
123 205 P205_WISER_ID Hidden 1 Wiser Id
123 205 P205_WR_ID Hidden 21 Wr Id

Message was edited by:
user486175

Message was edited by:
user486175