Hi everyone,
I got a new task at work, and my task is to generate XML through PL/SQL.
I am using Oracle 11g database, and SQL Developer 3.0.
The purpose of this procedure is to upload xml message to a queue, so my BPEL process can access the queue and process the message.
This is my first time writing a procedure that generates xml so bear with me.
Below is a sample of the xml file I received. I need to generate xml message below through PL/SQL. All the information in xml file will need to be retrieved from the database.
I need your help to start working on this procedure. Your help is very much appreciated.
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body xmlns:ns1="http://www.xxx.gov/soa/casefile/event/types">
<caseFileUploadEvent xmlns:xsi="http://www.w3XX.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.XXXX.gov/soa/casefile/event/types ../xsd/Case_META.xsd"
xmlns="http://www.XXXX.gov/soa/casefile/event/types">
<taskEvent>SUBMIT</taskEvent>
<defendentDetails>
<sentensingDate>2008-11-10-05:00</sentensingDate>
<personDetails>
<personNameDetails>
<firstName>FIRSTNAME</firstName>
<middleName>B</middleName>
<lastName>LASTNAME</lastName>
</personNameDetails>
<dateOfBirth>1969-09-23-04:00</dateOfBirth>
</personDetails>
</defendentDetails>
<documentStatusDetails>
<otherStatus>
<intCode>61</intCode>
<description>Other documents included</description>
</otherStatus>
</documentStatusDetails>
<uploadOtherDetails>
<submissionId>427000447</submissionId> // NOTE: SUBMISSIONID WILL BE PASSED IN THROUGH THE PROCEDURE TO QUERY ALL THE INFORMATION NEEDED FOR THE XML FILE
<submissionSessionId>401622</submissionSessionId>
<submissionMethod>
<intCode>1</intCode>
<description>WebApplication</description>
</submissionMethod>
<submissionReason>
<intCode>1</intCode>
<description>InitialSubmission</description>
</submissionReason>
<district>
<intCode>99</intCode>
<description>Test District</description>
</district>
<caseFileType>
<intCode>10</intCode>
<description>Individual - Original</description>
</caseFileType>
<primaryDocketInfo>
<yearYY>5</yearYY>
<id>55555</id>
<defendentNumber>555</defendentNumber>
</primaryDocketInfo>
<PACTSId>55555555</PACTSId>
<AOJudgeId>
<intCode>2512</intCode>
<description>FABER, DAVID, A.</description>
</AOJudgeId>
<missingCasefile>false</missingCasefile>
<creator>
<firstName>will</firstName>
<lastName>smith</lastName>
<email>wsmith@xxx.gov</email>
<actionDate>2005-09-07T09:48:09.811-04:00</actionDate>
</creator>
<lastModifier>
<firstName>john</firstName>
<lastName>doe</lastName>
<email>jdoe@xxx.gov</email>
<actionDate>2006-10-03T08:51:21.5-04:00</actionDate>
</lastModifier>
</uploadOtherDetails>
</caseFileUploadEvent>
</soap:Body>
</soap:Envelope>
procedure below
procedure upload_process(submission_id number) as
enqueue_options dbms_aq.enqueue_options_t;
message_properties dbms_aq.message_properties_t;
message_handle RAW(16);
message SYS.AQ$_JMS_TEXT_MESSAGE;
begin
// retrieve information from database based on submission_id (passed in), need help with this step
// generate XML, need help with this step
// send xml to queue, my queue name is cases_queue, code below, however not tested, I know I have to use ENQUEUE.
message := SYS.AQ$_JMS_TEXT_MESSAGE.construct; // my message is the xml data
message.set_text(xmldata.getStringVal());
DBMS_AQ.ENQUEUE(queue_name => 'cases_queue',
enqueue_options => enqueue_options,
message_properties => message_properties,
payload => message,
msgid => message_handle);
end upload_process;
Here is the DDL:
CREATE TABLE SUBMISSION
(
SUBMISSION_ID NUMBER (12) NOT NULL ,
SENT_ID NUMBER (12) ,
STATUS_CODE NUMBER (2) NOT NULL ,
CASE_TYPE_CODE NUMBER (2) NOT NULL ,
SUB_TYPE_CODE NUMBER (2) NOT NULL ,
SUB_MTHD_CODE NUMBER (2) NOT NULL ,
AMEND_CODE NUMBER (2) ,
CREATOR_ID VARCHAR2 (100 BYTE) ,
CREATE_DATE DATE DEFAULT SYSDATE NOT NULL ,
CREATE_TIME TIMESTAMP DEFAULT LOCALTIMESTAMP NOT NULL ,
SUB_SESSION_ID NUMBER (12) ,
SUB_NAME VARCHAR2 (100 BYTE) ,
SUB_EMAIL VARCHAR2 (100 BYTE) ,
SUB_PHONE VARCHAR2 (30 BYTE) ,
COMMENTS VARCHAR2 (1000 BYTE) ,
MISSING_CASE NUMBER (1)
) ;
ALTER TABLE SUBMISSION
ADD CONSTRAINT SUBMISSION_PK PRIMARY KEY ( SUBMISSION_ID ) ;
CREATE TABLE SUBMISSION_METADATA
(
SUBMISSION_ID NUMBER (12) NOT NULL ,
DIST_ID NUMBER (2) NOT NULL ,
AO_JUDGE_ID VARCHAR2 (4 BYTE) NOT NULL ,
PO_CODE VARCHAR2 (2 BYTE) ,
DOCKET VARCHAR2 (7 BYTE) NOT NULL ,
SENT_VIO_DATE DATE NOT NULL ,
CORP_NAME VARCHAR2 (255 BYTE) ,
LAST_NAME VARCHAR2 (50 BYTE) ,
FIRST_NAME VARCHAR2 (50 BYTE) ,
MIDDLE_NAME VARCHAR2 (50 BYTE) ,
SUFFIX_CODE VARCHAR2 (50 BYTE) ,
BIRTH_DATE DATE ,
JUDGE_NAME VARCHAR2 (100 BYTE) ,
DEF_NUM NUMBER (3) ,
ALT_DOCKET VARCHAR2 (7 BYTE) ,
ALT_DEF_NUM NUMBER (3) ,
PACTS_ID NUMBER (8) ,
ORIG_DEF_NUM NUMBER (3) ,
ORIG_DOCKET VARCHAR2 (7 BYTE) ,
ORIG_DIST_ID NUMBER (2) ,
TRUE_LAST_NAME VARCHAR2 (50 BYTE) ,
TRUE_FIRST_NAME VARCHAR2 (50 BYTE) ,
TRUE_MIDDLE_NAME VARCHAR2 (50 BYTE) ,
TRUE_SUFFIX_CODE VARCHAR2 (50 BYTE)
)
;
ALTER TABLE SUBMISSION_METADATA
ADD CONSTRAINT SUBMETA_PK PRIMARY KEY ( SUBMISSION_ID ) ;
CREATE TABLE CASE_HISTORY
(
HIST_ID NUMBER (12) NOT NULL ,
SUBMISSION_ID NUMBER (12) NOT NULL ,
STATUS_CODE NUMBER (2) NOT NULL ,
REJECT_CODE NUMBER (2) ,
USER_ID VARCHAR2 (100 BYTE) NOT NULL ,
ACTION_DATE DATE NOT NULL ,
REJECT_REMARKS VARCHAR2 (2000 BYTE)
)
;
ALTER TABLE CASE_HISTORY
ADD CONSTRAINT CASE_HISTORY_PK PRIMARY KEY ( HIST_ID ) ;
-- INSERT STATEMENTS
Insert into SUBMISSION (SUBMISSION_ID,SENT_ID,STATUS_CODE,CASE_TYPE_CODE,SUB_TYPE_CODE,SUB_MTHD_CODE,AMEND_CODE,CREATOR_ID,CREATE_DATE,CREATE_TIME,SUB_SESSION_ID,SUB_NAME,SUB_EMAIL,SUB_PHONE,COMMENTS,MISSING_CASE) values (798061057,638317,9,10,1,1,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),to_timestamp('29-JUN-07 02.00.00.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),116996,null,null,null,null,null);
Insert into SUBMISSION (SUBMISSION_ID,SENT_ID,STATUS_CODE,CASE_TYPE_CODE,SUB_TYPE_CODE,SUB_MTHD_CODE,AMEND_CODE,CREATOR_ID,CREATE_DATE,CREATE_TIME,SUB_SESSION_ID,SUB_NAME,SUB_EMAIL,SUB_PHONE,COMMENTS,MISSING_CASE) values (798203983,638264,9,10,1,1,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),to_timestamp('29-JUN-07 10.45.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),116900,null,null,null,null,0);
Insert into SUBMISSION (SUBMISSION_ID,SENT_ID,STATUS_CODE,CASE_TYPE_CODE,SUB_TYPE_CODE,SUB_MTHD_CODE,AMEND_CODE,CREATOR_ID,CREATE_DATE,CREATE_TIME,SUB_SESSION_ID,SUB_NAME,SUB_EMAIL,SUB_PHONE,COMMENTS,MISSING_CASE) values (798268035,638260,9,10,1,1,null,'XXX@XXX.GOV',to_date('30-JUN-07','DD-MON-RR'),to_timestamp('30-JUN-07 11.28.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),117151,null,null,null,null,null);
Insert into SUBMISSION (SUBMISSION_ID,SENT_ID,STATUS_CODE,CASE_TYPE_CODE,SUB_TYPE_CODE,SUB_MTHD_CODE,AMEND_CODE,CREATOR_ID,CREATE_DATE,CREATE_TIME,SUB_SESSION_ID,SUB_NAME,SUB_EMAIL,SUB_PHONE,COMMENTS,MISSING_CASE) values (798293718,638318,9,10,1,1,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),to_timestamp('29-JUN-07 04.48.00.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),117111,null,null,null,'JC - SOR SIGNED BY JUDGE',null);
Insert into SUBMISSION (SUBMISSION_ID,SENT_ID,STATUS_CODE,CASE_TYPE_CODE,SUB_TYPE_CODE,SUB_MTHD_CODE,AMEND_CODE,CREATOR_ID,CREATE_DATE,CREATE_TIME,SUB_SESSION_ID,SUB_NAME,SUB_EMAIL,SUB_PHONE,COMMENTS,MISSING_CASE) values (798376217,638261,9,10,1,1,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),to_timestamp('29-JUN-07 03.25.00.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),117068,null,null,null,null,null);
Insert into SUBMISSION (SUBMISSION_ID,SENT_ID,STATUS_CODE,CASE_TYPE_CODE,SUB_TYPE_CODE,SUB_MTHD_CODE,AMEND_CODE,CREATOR_ID,CREATE_DATE,CREATE_TIME,SUB_SESSION_ID,SUB_NAME,SUB_EMAIL,SUB_PHONE,COMMENTS,MISSING_CASE) values (798457995,638268,9,10,1,1,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),to_timestamp('29-JUN-07 10.32.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),116906,null,null,null,'RE-SUBMISSION ORIGINAL PRESENTENCE REPORT DID NOT SEND ADDENDUM AND SENTENCING RECOMMENDATION WITH PSR',null);
Insert into SUBMISSION (SUBMISSION_ID,SENT_ID,STATUS_CODE,CASE_TYPE_CODE,SUB_TYPE_CODE,SUB_MTHD_CODE,AMEND_CODE,CREATOR_ID,CREATE_DATE,CREATE_TIME,SUB_SESSION_ID,SUB_NAME,SUB_EMAIL,SUB_PHONE,COMMENTS,MISSING_CASE) values (798466161,638265,9,10,1,1,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),to_timestamp('29-JUN-07 09.38.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),116885,null,null,null,null,0);
Insert into SUBMISSION (SUBMISSION_ID,SENT_ID,STATUS_CODE,CASE_TYPE_CODE,SUB_TYPE_CODE,SUB_MTHD_CODE,AMEND_CODE,CREATOR_ID,CREATE_DATE,CREATE_TIME,SUB_SESSION_ID,SUB_NAME,SUB_EMAIL,SUB_PHONE,COMMENTS,MISSING_CASE) values (798471077,638316,9,10,1,1,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),to_timestamp('29-JUN-07 07.08.00.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),117146,null,null,null,null,null);
Insert into SUBMISSION_METADATA (SUBMISSION_ID,DIST_ID,AO_JUDGE_ID,PO_CODE,DOCKET,SENT_VIO_DATE,CORP_NAME,LAST_NAME,FIRST_NAME,MIDDLE_NAME,SUFFIX_CODE,BIRTH_DATE,JUDGE_NAME,DEF_NUM,ALT_DOCKET,ALT_DEF_NUM,PACTS_ID,ORIG_DEF_NUM,ORIG_DOCKET,ORIG_DIST_ID,TRUE_LAST_NAME,TRUE_FIRST_NAME,TRUE_MIDDLE_NAME,TRUE_SUFFIX_CODE) values (798061057,17,'17BG','5','0701077',to_date('12-JUN-07','DD-MON-RR'),null,'SMITH','RYAN','L',null,to_date('10-AUG-85','DD-MON-RR'),null,1,null,null,32498,null,null,null,null,null,null,null);
Insert into SUBMISSION_METADATA (SUBMISSION_ID,DIST_ID,AO_JUDGE_ID,PO_CODE,DOCKET,SENT_VIO_DATE,CORP_NAME,LAST_NAME,FIRST_NAME,MIDDLE_NAME,SUFFIX_CODE,BIRTH_DATE,JUDGE_NAME,DEF_NUM,ALT_DOCKET,ALT_DEF_NUM,PACTS_ID,ORIG_DEF_NUM,ORIG_DOCKET,ORIG_DIST_ID,TRUE_LAST_NAME,TRUE_FIRST_NAME,TRUE_MIDDLE_NAME,TRUE_SUFFIX_CODE) values (798203983,5,'0522','3','0600090',to_date('10-MAY-07','DD-MON-RR'),null,'JAMES','MARIO',null,null,to_date('14-APR-59','DD-MON-RR'),null,1,null,null,10619,null,null,null,null,null,null,null);
Insert into SUBMISSION_METADATA (SUBMISSION_ID,DIST_ID,AO_JUDGE_ID,PO_CODE,DOCKET,SENT_VIO_DATE,CORP_NAME,LAST_NAME,FIRST_NAME,MIDDLE_NAME,SUFFIX_CODE,BIRTH_DATE,JUDGE_NAME,DEF_NUM,ALT_DOCKET,ALT_DEF_NUM,PACTS_ID,ORIG_DEF_NUM,ORIG_DOCKET,ORIG_DIST_ID,TRUE_LAST_NAME,TRUE_FIRST_NAME,TRUE_MIDDLE_NAME,TRUE_SUFFIX_CODE) values (798268035,55,'5507','3','0600124',to_date('18-MAY-07','DD-MON-RR'),null,'SHOW','MICHAEL','D',null,to_date('14-JUL-81','DD-MON-RR'),null,1,null,null,9783,null,null,null,null,null,null,null);
Insert into SUBMISSION_METADATA (SUBMISSION_ID,DIST_ID,AO_JUDGE_ID,PO_CODE,DOCKET,SENT_VIO_DATE,CORP_NAME,LAST_NAME,FIRST_NAME,MIDDLE_NAME,SUFFIX_CODE,BIRTH_DATE,JUDGE_NAME,DEF_NUM,ALT_DOCKET,ALT_DEF_NUM,PACTS_ID,ORIG_DEF_NUM,ORIG_DOCKET,ORIG_DIST_ID,TRUE_LAST_NAME,TRUE_FIRST_NAME,TRUE_MIDDLE_NAME,TRUE_SUFFIX_CODE) values (798293718,41,'4123','8','0200472',to_date('08-JUN-07','DD-MON-RR'),null,'BARKLEY','OSCAR','M',null,to_date('04-MAR-81','DD-MON-RR'),null,2,null,null,234509,null,null,null,null,null,null,null);
Insert into SUBMISSION_METADATA (SUBMISSION_ID,DIST_ID,AO_JUDGE_ID,PO_CODE,DOCKET,SENT_VIO_DATE,CORP_NAME,LAST_NAME,FIRST_NAME,MIDDLE_NAME,SUFFIX_CODE,BIRTH_DATE,JUDGE_NAME,DEF_NUM,ALT_DOCKET,ALT_DEF_NUM,PACTS_ID,ORIG_DEF_NUM,ORIG_DOCKET,ORIG_DIST_ID,TRUE_LAST_NAME,TRUE_FIRST_NAME,TRUE_MIDDLE_NAME,TRUE_SUFFIX_CODE) values (798376217,66,'6621','4','0600189',to_date('15-MAY-07','DD-MON-RR'),null,'ARMSTRONG','LANCE',null,null,to_date('24-FEB-60','DD-MON-RR'),null,1,null,null,39382,null,null,null,null,null,null,null);
Insert into SUBMISSION_METADATA (SUBMISSION_ID,DIST_ID,AO_JUDGE_ID,PO_CODE,DOCKET,SENT_VIO_DATE,CORP_NAME,LAST_NAME,FIRST_NAME,MIDDLE_NAME,SUFFIX_CODE,BIRTH_DATE,JUDGE_NAME,DEF_NUM,ALT_DOCKET,ALT_DEF_NUM,PACTS_ID,ORIG_DEF_NUM,ORIG_DOCKET,ORIG_DIST_ID,TRUE_LAST_NAME,TRUE_FIRST_NAME,TRUE_MIDDLE_NAME,TRUE_SUFFIX_CODE) values (798457995,20,'2026','6','0600998',to_date('16-MAY-07','DD-MON-RR'),null,'FULLER','MIKE','E',null,to_date('24-DEC-62','DD-MON-RR'),null,11,null,null,26961,null,null,null,null,null,null,null);
Insert into SUBMISSION_METADATA (SUBMISSION_ID,DIST_ID,AO_JUDGE_ID,PO_CODE,DOCKET,SENT_VIO_DATE,CORP_NAME,LAST_NAME,FIRST_NAME,MIDDLE_NAME,SUFFIX_CODE,BIRTH_DATE,JUDGE_NAME,DEF_NUM,ALT_DOCKET,ALT_DEF_NUM,PACTS_ID,ORIG_DEF_NUM,ORIG_DOCKET,ORIG_DIST_ID,TRUE_LAST_NAME,TRUE_FIRST_NAME,TRUE_MIDDLE_NAME,TRUE_SUFFIX_CODE) values (798466161,4,'0412','3','0600288',to_date('16-MAY-07','DD-MON-RR'),null,'RAMOS','SERGIO','R',null,to_date('05-SEP-87','DD-MON-RR'),null,2,null,null,15776,null,null,null,null,null,null,null);
Insert into SUBMISSION_METADATA (SUBMISSION_ID,DIST_ID,AO_JUDGE_ID,PO_CODE,DOCKET,SENT_VIO_DATE,CORP_NAME,LAST_NAME,FIRST_NAME,MIDDLE_NAME,SUFFIX_CODE,BIRTH_DATE,JUDGE_NAME,DEF_NUM,ALT_DOCKET,ALT_DEF_NUM,PACTS_ID,ORIG_DEF_NUM,ORIG_DOCKET,ORIG_DIST_ID,TRUE_LAST_NAME,TRUE_FIRST_NAME,TRUE_MIDDLE_NAME,TRUE_SUFFIX_CODE) values (798471077,79,'79BA','6','0560106',to_date('12-JUN-07','DD-MON-RR'),null,'WILSON','RICHARD','G',null,to_date('14-NOV-78','DD-MON-RR'),null,1,null,null,37082,null,null,null,null,null,null,null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (86687,798268035,9,null,'DEVINE',to_date('02-JUL-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (86688,798376217,9,null,'LOCHARD',to_date('02-JUL-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (86689,798203983,9,null,'LOCHARD',to_date('02-JUL-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (86690,798466161,9,null,'DEVINE',to_date('02-JUL-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (86691,798457995,9,null,'WALKER',to_date('02-JUL-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (86692,798471077,9,null,'LAMPKIN',to_date('02-JUL-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (86693,798061057,9,null,'BULLARD',to_date('02-JUL-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (86694,798293718,9,null,'ADAMS',to_date('02-JUL-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (1549196,798268035,9,null,'XXX@XXX.GOV',to_date('30-JUN-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (1549197,798376217,9,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (1549198,798203983,9,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (1549199,798466161,9,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (1549200,798457995,9,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (1549201,798471077,9,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (1549202,798061057,9,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),null);
Insert into CASE_HISTORY (HIST_ID,SUBMISSION_ID,STATUS_CODE,REJECT_CODE,USER_ID,ACTION_DATE,REJECT_REMARKS) values (1549203,798293718,9,null,'XXX@XXX.GOV',to_date('29-JUN-07','DD-MON-RR'),null);
Thanks for the help.
Edited by: Rooney on Jan 24, 2012 9:10 AM
Edited by: Rooney on Jan 24, 2012 9:44 AM