In Oracle Stage i coded as update or insert but its not inse
Posted: Mon Jul 09, 2007 11:57 pm
In Oracle Stage i coded user defied sql as update or Insert, but its not inserting the records, can any one help in this regard.
This is my sql query
UPDATE #$SCHEMA_DWH#.DWH_S3_TAHGRP SET END_ACT_CD=:9,AVG_SALARY_AMT=:10,TOT_SALARY_AMT=:11,HIGH_SALARY_AMT=:12,SALARY_BAND_CD=:13,SALARY_FREQ_CD=:14,CATEGORY_NO=:15,PRINT_SEQ_NO=:16,ELIG_TXT=:17,NO_OF_EMPS=:18,VEH_MAKE_CD=:19,VEH_YEAR=:20,VEH_MODEL_CD=:21,VEH_LIC=:22,VEH_CAPACITY=:23,VEH_ENG_CAPACITY=:24,SI_UNIT=:25,MAX_UNIT=:26,SOURCE_SYSTEM_ID=:27,USERID_CD=:28,UPDATE_DATE=TO_DATE(:29, 'YYYY-MM-DD HH24:MI:SS'),DESTINATION_CD=:30,CONVEYANCE_CD=:31,TRIP_DURATION_DAYS=:32,NO_TRIPS_CNT=:33,ADDTL_EMP_ENDRSMT=:34 WHERE POLICY_NO=:1 AND POL_OFFICE_CD=:2 AND CERTIFICATE_NO=:3 AND RENL_CERT_NO=:4 AND EFF_DT_SEQ_NO=:5 AND LOCATION_NO=:6 AND SECT_OBJ_NO=:7 AND RISK_OBJ_NO=:8;
INSERT INTO #$SCHEMA_DWH#.DWH_S3_TAHGRP (POLICY_NO,POL_OFFICE_CD,CERTIFICATE_NO,RENL_CERT_NO,EFF_DT_SEQ_NO,LOCATION_NO,SECT_OBJ_NO,RISK_OBJ_NO,END_ACT_CD,AVG_SALARY_AMT,TOT_SALARY_AMT,HIGH_SALARY_AMT,SALARY_BAND_CD,SALARY_FREQ_CD,CATEGORY_NO,PRINT_SEQ_NO,ELIG_TXT,NO_OF_EMPS,VEH_MAKE_CD,VEH_YEAR,VEH_MODEL_CD,VEH_LIC,VEH_CAPACITY,VEH_ENG_CAPACITY,SI_UNIT,MAX_UNIT,SOURCE_SYSTEM_ID,USERID_CD,UPDATE_DATE,DESTINATION_CD,CONVEYANCE_CD,TRIP_DURATION_DAYS,NO_TRIPS_CNT,ADDTL_EMP_ENDRSMT) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,TO_DATE(:29, 'YYYY-MM-DD HH24:MI:SS'),:30,:31,:32,:33,:34)
Thanks in Advance
This is my sql query
UPDATE #$SCHEMA_DWH#.DWH_S3_TAHGRP SET END_ACT_CD=:9,AVG_SALARY_AMT=:10,TOT_SALARY_AMT=:11,HIGH_SALARY_AMT=:12,SALARY_BAND_CD=:13,SALARY_FREQ_CD=:14,CATEGORY_NO=:15,PRINT_SEQ_NO=:16,ELIG_TXT=:17,NO_OF_EMPS=:18,VEH_MAKE_CD=:19,VEH_YEAR=:20,VEH_MODEL_CD=:21,VEH_LIC=:22,VEH_CAPACITY=:23,VEH_ENG_CAPACITY=:24,SI_UNIT=:25,MAX_UNIT=:26,SOURCE_SYSTEM_ID=:27,USERID_CD=:28,UPDATE_DATE=TO_DATE(:29, 'YYYY-MM-DD HH24:MI:SS'),DESTINATION_CD=:30,CONVEYANCE_CD=:31,TRIP_DURATION_DAYS=:32,NO_TRIPS_CNT=:33,ADDTL_EMP_ENDRSMT=:34 WHERE POLICY_NO=:1 AND POL_OFFICE_CD=:2 AND CERTIFICATE_NO=:3 AND RENL_CERT_NO=:4 AND EFF_DT_SEQ_NO=:5 AND LOCATION_NO=:6 AND SECT_OBJ_NO=:7 AND RISK_OBJ_NO=:8;
INSERT INTO #$SCHEMA_DWH#.DWH_S3_TAHGRP (POLICY_NO,POL_OFFICE_CD,CERTIFICATE_NO,RENL_CERT_NO,EFF_DT_SEQ_NO,LOCATION_NO,SECT_OBJ_NO,RISK_OBJ_NO,END_ACT_CD,AVG_SALARY_AMT,TOT_SALARY_AMT,HIGH_SALARY_AMT,SALARY_BAND_CD,SALARY_FREQ_CD,CATEGORY_NO,PRINT_SEQ_NO,ELIG_TXT,NO_OF_EMPS,VEH_MAKE_CD,VEH_YEAR,VEH_MODEL_CD,VEH_LIC,VEH_CAPACITY,VEH_ENG_CAPACITY,SI_UNIT,MAX_UNIT,SOURCE_SYSTEM_ID,USERID_CD,UPDATE_DATE,DESTINATION_CD,CONVEYANCE_CD,TRIP_DURATION_DAYS,NO_TRIPS_CNT,ADDTL_EMP_ENDRSMT) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,TO_DATE(:29, 'YYYY-MM-DD HH24:MI:SS'),:30,:31,:32,:33,:34)
Thanks in Advance