Oracle 数据库链接查询

创建或替换过程P_POP_ILC (P_POL_NO VARCHAR2默认为NULL)
是

cursor c1 是
选择 *
从rsds_locn _ 曝光 @ dmn_rsk_150
哪里
RLE_ULM_NO = NVL(P_POL_NO，RLE_ULM_NO);

开始
从IDS_LOCN_CLM @ dmn_rsk_150中删除;
提交;

对于c1循环中的i
插入IDS_LOCN_CLM @ dmn_rsk_150
(ILC_ULM_NO，
ILC_DIVN，
ILC_DEPT，
ILC_SRC_BUS，
ILC_CLM_NO，
ILC_RISK_ID，
Ilc_los_typ，
Ilc_event _code，
Ilc_event _desc，
Ilc_losd，
ILC_INTD，
Ilc _ 状态，
ILC_PAY_EST_AMT，
ILC_REC_EST_AMT，
ILC_PAY_PAID_AMT，
ILC_REC_AMT，
ILC_PAY_OS_AMT，
ILC_REC_OS_AMT，
ILC_SYS_UPD，
ILC_PAY_RET_EST，
Ilc_pay_ret_pay，
ILC_PAY_RET_OS，
ILC_PAY_QS_EST，
Ilc_pay_qs_pays，
ILC_PAY_QS_OS，
ILC_PAY_1S_EST，
Ilc_pay_1s_pays，
ILC_PAY_1S_OS，
ILC_PAY_2S_EST，ilc_pay_2s_pay_2s_os，ILC_PAY_FAC_EST，ilc_pay_fac_pay, ILC_PAY_FAC_OS，ILC_PAY_FAC_OB_EST，
Ilc_pay_fac_ob_pay,ilc_pay_fac_ob_os，ILC_REC_RET_EST，ilc_rec_ret_pay, ILC_REC_RET_OS，ILC_REC_QS_EST，
Ilc_rec_qs_payed，ILC_REC_QS_OS，ILC_REC_1S_EST，ilc_rec_1s_payed，ILC_REC_1S_OS，ILC_REC_2S_EST，ilc_rec_2s_payed，
ILC_REC_2S_OS，ILC_REC_FAC_EST，ilc_rec_fac_ped，ILC_REC_FAC_OS，ILC_REC_FAC_OB_EST，ilc_rec_fac_ob_ped，
ILC_REC_FAC_OB_OS，ILC_XOL1_EST，ilc_xol1_ped，ILC_XOL1_OS，ILC_XOL2_EST，ilc_xol2_ped，ILC_XOL2_OS，
ILC_XOL3_EST，ilc_xol3_pid，ILC_XOL3_OS)
选择CLF_ULM_NO，
CLF_DIVN_ID，CLF_DEPT_ID，'DIRECT'，CLF_CLC_NO，
CLE_RISK_ID,--(select CLE_RISK_ID from ctds_level_e 哪里cle_clf_sgs_id= clf_sgs_id ),
(select UID_DESC from uds_id_defn 哪里uid_id_typ ='LOSS_TYP' and uid_id =CLE_LOSS_ID and UID_UP_PROD_ID =clf_prod_id) a,
空，空，CLF_CLD，CLF_CID，CLF_STATUS，
--(select clc_status from ctds_level_c 哪里clc_clf_sgs_id =clf_sgs_id and CLC_NO = CLF_CLC_NO)
(select sum(CLE_EST_AMT)from ctds_level_e B 哪里cle_clf_sgs_id= clf_sgs_id AND B.CLE_SGS_ID = A.CLE_SGS_ID AND B.CLE_RISK_ID = A.CLE_RISK_ID and CLE_TYP ='P'and B.CLE_LOSS_ID = A.CLE_LOSS_ID and CLE_CVR_ID <>'*'),
(select sum(CLE_EST_AMT)from ctds_level_e B 哪里cle_clf_sgs_id= clf_sgs_id AND B.CLE_SGS_ID = A.CLE_SGS_ID AND B.CLE_RISK_ID = A.CLE_RISK_ID and CLE_TYP ='R' and CLE_CVR_ID <>'*'),
(select sum(CLS_PAY_AMT) from ctds_level_s 哪里cls_clf_sgs_id =clf_sgs_id and cls_cle_sgs_id = A.cle_sgs_id and CLS_RISK_ID= A.CLE_RISK_ID and CLE_CVR_ID <>'*' ) PAY_PAID_AMT,
null，
(select sum(CLE_OS_AMT) from ctds_level_e B 哪里cle_clf_sgs_id = clf_sgs_id AND B.CLE_SGS_ID = A.CLE_SGS_ID AND B.CLE_RISK_ID = A.CLE_RISK_ID and CLE_TYP ='P' and CLE_CVR_ID <>'*'),
(select sum(CLE_OS_AMT) from ctds_level_e B 哪里cle_clf_sgs_id = clf_sgs_id AND B.CLE_SGS_ID = A.CLE_SGS_ID AND B.CLE_RISK_ID = A.CLE_RISK_ID and CLE_TYP ='R' and CLE_CVR_ID <>'*'),
Null，
--(select SUM(RLM_AMT)from rtds_level_mcr 哪里rlm_clm_no = CLF_CLC_NO and RLM_CLE_SGS_ID = A.CLE_SGS_ID and RLM_LOSS_ID = A.CLE_LOSS_ID AND RLM_SR_NO = A.CLE_SR_NO),
(select SUM(RLM_TTY_RETN_AMT_BC)from rtds_level_mcr 哪里rlm_clm_no = CLF_CLC_NO and RLM_CLE_SGS_ID = A.CLE_SGS_ID and RLM_LOSS_ID =A. CLE_LOSS_ID AND RLM_SR_NO = A.CLE_SR_NO),
(select SUM(RLM_TTY_RETN_AMT_BC)from rtds_level_mcr 哪里rlm_clm_no = CLF_CLC_NO and RLM_CLE_SGS_ID = A.CLE_SGS_ID and RLM_LOSS_ID = A.CLE_LOSS_ID and rlm_rec_typ = 'S' AND RLM_SR_NO = A.CLE_SR_NO),
(select SUM(RLM_TTY_RETN_AMT_BC)from rtds_level_mcr 哪里rlm_clm_no = CLF_CLC_NO and RLM_CLE_SGS_ID = A.CLE_SGS_ID and RLM_LOSS_ID = A.CLE_LOSS_ID and rlm_rec_typ = 'E' AND RLM_SR_NO = A.CLE_SR_NO),
(select SUM(RLM_TTY_AMT_BC)from rtds_level_mcr 哪里rlm_clm_no = CLF_CLC_NO and RLM_CLE_SGS_ID = A.CLE_SGS_ID and RLM_LOSS_ID = A.CLE_LOSS_ID AND RLM_SR_NO = A.CLE_SR_NO ),
(select SUM(RLM_TTY_AMT_BC)from rtds_level_mcr 哪里rlm_clm_no = CLF_CLC_NO and RLM_CLE_SGS_ID = A.CLE_SGS_ID and RLM_LOSS_ID = A.CLE_LOSS_ID and rlm_rec_typ = 'S' AND RLM_SR_NO = A.CLE_SR_NO),
(select SUM(RLM_TTY_AMT_BC)from rtds_level_mcr 哪里rlm_clm_no = CLF_CLC_NO and RLM_CLE_SGS_ID = A.CLE_SGS_ID and RLM_LOSS_ID = A.CLE_LOSS_ID and rlm_rec_typ = 'E' AND RLM_SR_NO = A.CLE_SR_NO),
(select SUM(RLD_RI_AMT) from rtds_level_dcr 哪里rld_mcr_sgs_id in (select rlm_mcr_Sgs_id from rtds_level_mcr 哪里rlm_clm_no = CLF_CLC_NO )
和RLD_REC_TYP = 'E' 和RLD_LVL_NO = '2 ')，
(select SUM(RLD_RI_AMT) from rtds_level_dcr 哪里rld_mcr_sgs_id in (select rlm_mcr_Sgs_id from rtds_level_mcr 哪里rlm_clm_no = CLF_CLC_NO )
和RLD_REC_TYP = 'S' 和RLD_LVL_NO = '2')，NULL，
(从FTDS_LEVEL_MCR中选择SUM(FLM_FAC_AMT)，其中FLM_CLM_NO = CLF_CLC_NO和FLM_CLE_SGS_ID = A.CLE_SGS_ID和FLM_CVR_ID <> '*' 和FLM_LOSS_ID = A.CLE_LOSS_ID和FLM_SR_NO = A.CLE_SR_NO)，
(从FTDS_LEVEL_MCR中选择SUM(FLM_FAC_AMT)，其中FLM_CLM_NO = CLF_CLC_NO和FLM_CLE_SGS_ID = A.CLE_SGS_ID和FLM_CVR_ID <> '*' 和FLM_LOSS_ID = A.CLE_LOSS_ID和FLM_REC_TYP = 'S' 和FLM_SR_NO = A.CLE_SR_NO)，
(从FTDS_LEVEL_MCR中选择SUM(FLM_FAC_AMT)，其中FLM_CLM_NO = CLF_CLC_NO和FLM_CLE_SGS_ID = A.CLE_SGS_ID和FLM_CVR_ID <> '*' 和FLM_LOSS_ID = A.CLE_LOSS_ID和FLM_REC_TYP = 'E' 和FLM_SR_NO = A.CLE_SR_NO)，
null，null，NULL,null，null，NULL,null，null，NULL,null，null，NULL,null，null，NULL,null，
null，NULL,null，null，NULL,null，null，NULL,null，null，NULL,null，null，NULL,null，null，NULL
从ctds_level_fnol，CTDS_LEVEL_E A
哪里CLF_ULM_NO = i.RLE_ULM_NO
-CLF_CLC_NO in (“c/55/055/02/1003/18/001/000010”，“c/55/055/02/1003/18/001/000006”，“c/55/055/02/1003/18/001/000011”)
和CLF_SGS_ID = CLE_CLF_SGS_ID;
结束循环;
UWP_INS_LOCN_CLM @ dmn_rsk_150(P_POL_NO);
结束;


th是 是 my procedure here the db libk 是 hardcoded so i have not compile th是 procedure to other db how to do avoid th是 hardcoded db link wat to do???

你应该硬编码你的数据库链接名称。它是对象标识符的一部分。

动态地执行此操作会使您面临SQL注入的风险。允许人们更改数据库链接名称，使他们可以轻松地在网络中的任何数据库上运行代码。坏主意!