ORA-01795: 列表中的最大表示式數為 1000解決方法

v_update_string := 'UPDATE tmp_cashflow set match_id = ' || v_match_id || ' where cashflow_id in (' || p_cashflow_string || ')';

[@more@]

ORA-01795: maximum number of expressions in a list is 1000

ORA-06512: at line 1

ORA-06512: at "MOARUSR.P_EXCP", line 227

ORA-06512: at "MOARUSR.P_FEED", line 1057

ORA-01795: maximum number of expressions in a list is 1000

ORA-06512: at line 1

ORA-06512: at "MOARUSR.P_EXCP", line 227

ORA-06512: at "MOARUSR.P_MATCH", line 1480

ORA-01795: maximum number of expressions in a list is 1000

ORA-06512: at line 1