Home » RDBMS Server » Server Administration » ORA-01410:INVALID
| ORA-01410:INVALID [message #56191] |
Tue, 11 March 2003 19:44 |
Jay
Messages: 127
Registered: October 1999
|
Senior Member |
|
|
Hi Guys,
I am getting the following error message when executing the following stored proc please help.
CREATE OR REPLACE PROCEDURE prc_lc_s_compare_detail
IS
CURSOR Compare_Summa IS
SELECT
pc_Cont ,td_Acc_code,td_Div_Code,MAX(tc_txn_num) ,pc_lst_txn_date,
td_units,TD_INV_VALUE_AMT ,pc_batch_id
FROM t_litc_Transaction_common d ,t_litt_transaction_type_Code f,t_litd_transaction_detail g,t_lipc_policy_Common,
(
SELECT a.tc_pol_num,MAX(tt_txn_type_code) tt_txn_type_code,tmax_date FROM t_litc_Transaction_common a,t_litt_transaction_type_code,
(SELECT tc_pol_num,MAX(tc_txn_date) tmax_date FROM t_litc_transaction_Common WHERE
tc_txn_status='D' AND ( tc_txn_type != 21 AND tc_Txn_type != 22 AND tc_txn_Type != 5 ) GROUP BY tc_pol_num ) b
WHERE a.tc_pol_num = b.tc_pol_num AND a.tc_txn_Date=tmax_date
AND a.tc_Txn_Type=tt_Txn_type AND tc_Txn_status='D' AND ( tc_txn_type != 21 AND tc_Txn_type != 22 AND tc_txn_Type != 5 )
GROUP BY a.tc_pol_num,tmax_date
) e
WHERE d.tc_pol_num=pc_pol_num AND pc_status IN ( 'C','D','G' ) AND
tt_Txn_type=tc_txn_type AND d.tc_pol_num=e.tc_pol_num AND f.tt_Txn_Type_code = e.tt_txn_type_Code
AND d.tc_txn_date=tmax_Date AND g.td_Txn_num=d.tc_txn_num
AND tc_txn_status='D' AND pc_cont='A3697515941'
GROUP BY
pc_Cont ,td_Acc_code,td_Div_Code,pc_lst_txn_date,
td_units,TD_INV_VALUE_AMT ,pc_batch_id;
/* SELECT pc_Cont,td_acc_code,td_div_code,tc_Txn_date,td_units,
TD_INV_VALUE_AMT ,pc_batch_id
FROM t_lipc_policy_common,t_litc_transaction_Common,
t_litd_transaction_detail
WHERE pc_pol_num=tc_pol_num AND tc_txn_num=td_txn_num AND tc_txn_num=323438;
*/
INV_VALUE NUMBER(38,16);
ACC_CODE VARCHAR2(3);
DIV_CODE VARCHAR2(3);
UNITS NUMBER(38,16);
VAL_DATE DATE;
CONT_NO VARCHAR2(15);
BATCH_ID NUMBER(16) := 0;
tc_txn number(16) := 0;
BEGIN
-- {
OPEN Compare_Summa;
BEGIN
LOOP
BEGIN
FETCH Compare_Summa
INTO
CONT_NO, ACC_CODE, DIV_CODE, tc_txn,
VAL_DATE, UNITS, INV_VALUE, BATCH_ID;
EXIT WHEN Compare_Summa%NOTFOUND;
EXCEPTION WHEN OTHERS THEN RAISE;
END;
--show('before policy compare->......');
PRC_LC_S_POLICY_COMPARE (ACC_CODE, DIV_CODE, CONT_NO, '20021204', INV_VALUE, UNITS, BATCH_ID);
END LOOP;
EXCEPTION WHEN OTHERS THEN RAISE;
END;
-- }
END;
/
|
|
|
|
Goto Forum:
Current Time: Sun Dec 29 00:13:54 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
