question

taj avatar image
taj asked

How do I convert Oracle code having types.ref_cursor to SQL Server 2008 code

**here in following procedure types.ref_cursor used as datatype. i know that in SQL Server there is no exact same concept. please help me, guide me to convert following code to related SQL Server code** procedure USP_GET_FILTERS_BOM(p_routing out types.ref_cursor, p_origin out types.ref_cursor, p_source out types.ref_cursor, p_type out types.ref_cursor, p_scope out types.ref_cursor, p_currency out types.ref_cursor, p_iserror out number) as e_no_routing exception; -- declare the exception pragma EXCEPTION_INIT(e_no_routing, -20031); -- bind the exception to the exception number e_no_origin exception; -- declare the exception pragma EXCEPTION_INIT(e_no_origin, -20032); -- bind the exception to the exception number e_no_source exception; -- declare the exception pragma EXCEPTION_INIT(e_no_source, -20033); -- bind the exception to the exception number e_no_type exception; -- declare the exception pragma EXCEPTION_INIT(e_no_type, -20034); -- bind the exception to the exception number e_no_scope exception; -- declare the exception pragma EXCEPTION_INIT(e_no_scope, -20035); -- bind the exception to the exception number e_no_currency exception; -- declare the exception pragma EXCEPTION_INIT(e_no_currency, -20072); -- bind the exception to the exception number v_isvalid number; v_estimate_exists number; -- 0- v_item_exists number; -- 1- v_routing_exists number; --2- v_source_exists number; --3- v_type_exists number; --4- v_origin_exists number; --5- v_scope_exists number; --6- v_currency_exists number; --6- v_estimate number; v_revision number; v_routing varchar(50); v_source varchar(50); v_type varchar(50); v_origin varchar(50); v_scope varchar(50); v_rowid varchar(50); interfaceBom_rec TBL_EAQ_INTERFACE_BOM%ROWTYPE; begin v_estimate_exists :=0; -- 0- v_item_exists :=0; -- 1- v_routing_exists :=0; --2- v_source_exists :=0; --3- v_type_exists :=0; --4- v_origin_exists :=0; --5- v_scope_exists:=0; --6- v_currency_exists:=0; v_isvalid:=1; p_iserror:=0; --2-Routing -- check valid Routing available in master open p_routing for --open the cursor select * from ESS_MASTERS where 1=2 ; PKG_ESS_MASTERS.USP_GET_LIST( PKG_EAQ_CONFIGS.c_Application_id,'ROUTING',p_routing,p_iserror); --3-Source -- check valid Source available in master open p_source for --open the cursor select * from ESS_MASTERS where 1=2 ; PKG_ESS_MASTERS.USP_GET_LIST( PKG_EAQ_CONFIGS.c_Application_id,'SOURCE',p_source,p_iserror); --4-type -- check valid type available in master open p_type for --open the cursor select * from ESS_MASTERS where 1=2 ; PKG_ESS_MASTERS.USP_GET_LIST( PKG_EAQ_CONFIGS.c_Application_id,'TYPE',p_type,p_iserror); --5-origin -- check valid type available in master open p_origin for --open the cursor select * from ESS_MASTERS where 1=2 ; PKG_ESS_MASTERS.USP_GET_LIST( PKG_EAQ_CONFIGS.c_Application_id,'ORIGIN',p_origin,p_iserror); --6-Scope -- check valid Scope available in master open p_scope for --open the cursor select * from ESS_MASTERS where 1=2 ; PKG_ESS_MASTERS.USP_GET_LIST( PKG_EAQ_CONFIGS.c_Application_id,'SCOPE',p_scope,p_iserror); --7-Valid Currencies -- check valid curencies available in master open p_currency for --open the cursor select a.ID ID, a.CURRENCY CURRENCY, b.CURRENCY_NAME CURRENCY_NAME from TBL_EAQ_EXG_RATE a, ESS_CURRENCY b where trunc(sysdate)>=trunc(a.effective_start_date) and trunc(sysdate)<=trunc(a.effective_end_date) and a.CURRENCY=b.CURRENCY(+) and 1=2 ; -- start checking Currencies select count(*) into v_currency_exists from TBL_EAQ_EXG_RATE where trunc(sysdate)>=trunc(effective_start_date) and trunc(sysdate)<=trunc(effective_end_date); -- Scope data does not exist. if v_currency_exists <= 0 then-- if the Currencies data does not exists raise e_no_currency;--raise an exception if Currencies data does not exist. else open p_currency for --open the cursor select a.ID ID, a.CURRENCY CURRENCY, b.CURRENCY_NAME CURRENCY_NAME from TBL_EAQ_EXG_RATE a, ESS_CURRENCY b where trunc(sysdate)>=trunc(a.effective_start_date) and trunc(sysdate)<=trunc(a.effective_end_date) and a.CURRENCY=b.CURRENCY(+) order by b.CURRENCY_NAME; end if; end --USP_GET_FILTERS_BOM; -------------------------------- procedure USP_GET_LIST(p_appl_id in number, p_master_type in varchar, p_master_list out types.ref_cursor, p_iserror out number) AS e_invalid_appl_id exception; -- declare the exception PRAGMA EXCEPTION_INIT(e_invalid_appl_id, -20001); -- bind the exception to the exception number e_invalid_master_type exception; -- declare the exception PRAGMA EXCEPTION_INIT(e_invalid_master_type, -20002); -- bind the exception to the exception number e_others exception; -- declare the exception PRAGMA EXCEPTION_INIT(e_others, -20003); -- bind the exception to the exception number v_master_type_exists number; --v_master_type_exists number; begin p_iserror := 0; -- initialize the ISERROR to zero i.e. there are no execption -- DBMS_OUTPUT.PUT_LINE('In procedure :'||PKG_ESS_CONFIGS.c_Application_id); if p_appl_id <= 0 then p_iserror :=1; raise e_invalid_appl_id;---raise an exception if applicaiton id is less than or equal to zero. else if p_master_type = null then begin p_iserror :=1; raise e_invalid_master_type;--raise an exception if master type is blank. end; else select count(*) -- check if records exists into v_master_type_exists from ESS_MASTERS where APPL_ID = p_appl_id and MASTER_TYPE = p_master_type and ACTIVE=1 and SHOW=1; DBMS_OUTPUT.PUT_LINE('calling v_master_type_exists:'||v_master_type_exists); if v_master_type_exists > 0 then-- if the given master type exists Begin OPEN p_master_list FOR --open the cursor select ID, APPL_ID, MASTER_TYPE, MASTER_VALUE, DESCRIPTION, SEQ_ORDER, ACTIVE, SHOW, DEFAULT_VALUE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, CREATED_BY, CREATED_ON, MODIFIED_BY, MODIFIED_ON, PARENT from ESS_MASTERS where APPL_ID=p_appl_id and MASTER_TYPE=p_master_type and ACTIVE=1 and SHOW=1 order by SEQ_ORDER,MASTER_VALUE; end; else begin p_iserror :=1; raise e_invalid_master_type;--raise an exception if master type is not available in master. end; end if; end if; end if; end --USP_GET_LIST; ------------------------------------------------- CREATE TABLE "CUSTOM"."ESS_MASTERS" ( "ID" NUMBER, "APPL_ID" NUMBER, "MASTER_TYPE" VARCHAR2(50 BYTE), "MASTER_VALUE" VARCHAR2(100 BYTE), "DESCRIPTION" VARCHAR2(500 BYTE), "SEQ_ORDER" NUMBER, "ACTIVE" NUMBER, "SHOW" NUMBER, "DEFAULT_VALUE" NUMBER, "ATTRIBUTE1" NUMBER, "ATTRIBUTE2" NUMBER, "ATTRIBUTE3" DATE, "ATTRIBUTE4" DATE, "ATTRIBUTE5" VARCHAR2(50 BYTE), "ATTRIBUTE6" VARCHAR2(50 BYTE), "ATTRIBUTE7" VARCHAR2(50 BYTE), "ATTRIBUTE8" VARCHAR2(250 BYTE), "ATTRIBUTE9" VARCHAR2(250 BYTE), "ATTRIBUTE10" VARCHAR2(250 BYTE), "CREATED_BY" NUMBER, "CREATED_ON" DATE, "MODIFIED_BY" NUMBER, "MODIFIED_ON" DATE, "PARENT" NUMBER DEFAULT 0, CONSTRAINT "PK_ESS_MASTERS_ID" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "THL_INDEX" ENABLE, CONSTRAINT "FK_ESS_MASTERS_APPL_ID" FOREIGN KEY ("APPL_ID") REFERENCES "CUSTOM"."HAIL_APPLMGR_APPLICATIONS" ("APPL_ID") ENABLE ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "THL_DATA" ; ------------ ---------- Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (1,58,'REQUEST_TYPE','Repairs','abcd',1,1,1,1,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (2,58,'REQUEST_TYPE','Return','abcd',2,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (3,58,'REQUEST_TYPE','Root Cause Failure Analysis','abcd',3,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (4,58,'GRADE','A [Looking as brand New]','abcd',1,1,1,1,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (5,58,'GRADE','B [Looking new (slightly used) but no scratches or marks on it(clean one)]','abcd',2,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (6,58,'GRADE','C [Looking used/old one]','abcd',3,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (7,58,'GRADE',' D [Looking used/old with scratches, marks]','abcd',4,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (8,58,'FAULT_NATURE','Self Test Failed','abcd',1,1,1,1,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (9,58,'FAULT_NATURE','Running Failure','abcd',2,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (10,58,'FAULT_NATURE','Intermittant Failure','abcd',3,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (11,58,'FAULT_NATURE','Others','abcd',4,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (12,58,'FAILURE_CAUSE','Effect of Surrounding Conditions','abcd',1,1,1,1,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (122,58,'FAILURE_CAUSE','Others','abcd',2,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (13,58,'SHIPPED_FROM','HAIL Regional Office','abcd',1,1,1,1,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (14,58,'SHIPPED_FROM','Customer Site','abcd',2,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (74,58,'PROJECT_STATUS','OPEN','for open projects',1,1,1,1,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (75,58,'PROJECT_STATUS','CLOSED','for closed projects',2,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (123,58,'REPLACEMENT_SCOPE','Free replacement as per contract ','REPLACEMENT_SCOPE',1,1,1,1,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (124,58,'REPLACEMENT_SCOPE','Chargeable replacement as per contract','REPLACEMENT_SCOPE',2,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (125,58,'REPLACEMENT_SCOPE','Chargeable (no specific material replacement agreement in contract).','REPLACEMENT_SCOPE',3,1,1,0,null,null,null,null,null,null,null,null,null,null,8704,to_date('26-NOV-07','DD-MON-RR'),8704,to_date('26-NOV-07','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (126,62,'EXECUTION_SCOPE','Supply Hardware',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (127,62,'EXECUTION_SCOPE','Supply Software',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (128,62,'EXECUTION_SCOPE','Services',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (129,62,'CONTRACT_TYPE','Comprehensive',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (130,62,'CONTRACT_TYPE','Non Comprehensive',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (131,62,'CONTRACT_TYPE','Hardware Support',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (132,62,'CONTRACT_SUB_TYPE','Ceiling',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (133,62,'CONTRACT_SUB_TYPE','Non Ceiling',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (134,62,'COST_CENTER','Factory',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (135,62,'COST_CENTER','BU Comm',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (136,62,'COST_CENTER','BU Ops',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (137,62,'COST_CENTER','BU VM',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (138,62,'COST_CENTER','Engg Mgr',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (139,62,'COST_CENTER','Purchase',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (140,62,'COST_CENTER','AMS Ops',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (141,62,'REVENUE_GROUP','Domestic',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (142,62,'REVENUE_GROUP','Imports',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (143,62,'VERTICAL_MARKET','Power- Power Generation and Transmission',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (144,62,'VERTICAL_MARKET','MMM- Metals, Minerals and Mining',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (145,62,'VERTICAL_MARKET','PPP- Paper and Pulp',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (146,62,'VERTICAL_MARKET','HPI- Hydrocarbon Processing Industries',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (147,62,'VERTICAL_MARKET','CLS- Chemicals and Life Sciences',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (148,62,'VERTICAL_MARKET','OGD- Oil and Gas Downstream',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (149,62,'VERTICAL_MARKET','OGU- Oil and Gas Upstream',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (150,62,'HONEYWELL_PORTFOLIO','Service Projects',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (151,62,'HONEYWELL_PORTFOLIO','Demand Parts',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (152,62,'HONEYWELL_PORTFOLIO','Service Contracts',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (153,62,'HONEYWELL_PORTFOLIO','Demand Service',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (154,62,'HAIL_PORTFOLIO','AMC/OTS',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (155,62,'HAIL_PORTFOLIO','Modular',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); Insert into ESS_MASTERS (ID,APPL_ID,MASTER_TYPE,MASTER_VALUE,DESCRIPTION,SEQ_ORDER,ACTIVE,SHOW,DEFAULT_VALUE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIED_ON,PARENT) values (156,62,'HAIL_PORTFOLIO','Migration',null,0,1,1,null,null,null,null,null,null,null,null,null,null,null,31372,to_date('08-JAN-08','DD-MON-RR'),31372,to_date('08-JAN-08','DD-MON-RR'),0); **this is oracle code**
sql-server-2008oracle
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
They look like tables, so I would look at using table-valued parameters : https://msdn.microsoft.com/en-us/library/bb510489(v=sql.100).aspx
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

taj avatar image taj commented ·
how do i implement here table-valued parameters.. plz tell me with an example
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
There is an example in the BOL link - I cannot recreate it for your scenario as I do not know the structure of ESS_MASTERS nor what is returned from PKG_ESS_MASTERS.USP_GET_LIST
0 Likes 0 ·
taj avatar image taj commented ·
sorry to add all things but just give me an idea how do I write above oracle code into sql server script
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
Here's an example of a table-valued parameter that I gave you for an earlier question : https://ask.sqlservercentral.com/questions/116533/migration-of-oracle-array-to-sql-server.html
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.