M
Mike
How do I execute two consecutive insert statements against an oracle database
here is the insert that was result of a response.write
Insert into ACTIVITY_TRACKING (AT_KEY, AT_PR_KEY, AT_EM_KEY, AT_DATE,
AT_RC_RUN_ID, AT_PASS_FAIL, AT_Number_of_Samples, AT_OTHER_ACTIVITIES) Values
(ACTIVITY_TRACKING_SEQ.nextval, 39133, 203938, '28-Dec-2005', 503320, 'P',
12, ''); Insert Into Activities_ICD (AI_Key, AI_AT_Key, AI_Activity) Values
(ACTIVITIES_ICD_SEQ.nextval, ACTIVITY_TRACKING_SEQ.currval, 'clean');
The statement is complaining about the ";" that separates the two inserts.
Thanks
Mike
here is the insert that was result of a response.write
Insert into ACTIVITY_TRACKING (AT_KEY, AT_PR_KEY, AT_EM_KEY, AT_DATE,
AT_RC_RUN_ID, AT_PASS_FAIL, AT_Number_of_Samples, AT_OTHER_ACTIVITIES) Values
(ACTIVITY_TRACKING_SEQ.nextval, 39133, 203938, '28-Dec-2005', 503320, 'P',
12, ''); Insert Into Activities_ICD (AI_Key, AI_AT_Key, AI_Activity) Values
(ACTIVITIES_ICD_SEQ.nextval, ACTIVITY_TRACKING_SEQ.currval, 'clean');
The statement is complaining about the ";" that separates the two inserts.
Thanks
Mike