oracle报错pls 00498,PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted

Hi All,

Declared below function in package spec and body.

FUNCTION update_cust_trx (cust_trx_id in number,

p_term_count in number,

P_PRINTING_COUNT  in number,

P_ORIG_DATE in DATE,

P_TERM_SEQ in NUMBER,

P_TRX_TYPE in varchar2,

P_TER_REL_AMT in NUMBER

)

RETURN varchar2

IS

cust_trx_id  NUMBER;

BEGIN

UPDATE ra_customer_trx

SET printing_pending = Decode (P_TRX_TYPE, 'CM', 'N',Decode(p_term_count, Greatest(Nvl(last_printed_sequence_num, 0),P_TERM_SEQ), 'N',

NULL, 'N',

1, 'N',

0, 'N',

'Y')),

printing_count = Decode(P_PRINTING_COUNT, NULL, 0, P_PRINTING_COUNT)+ 1,

printing_last_printed = SYSDATE,

printing_original_date = Decode(P_PRINTING_COUNT, 0, SYSDATE,P_ORIG_DATE),

last_printed_sequence_num = Decode(p_term_count, NULL, NULL,Greatest(Nvl(last_printed_sequence_num, 0),P_TERM_SEQ))

WHERE  customer_trx_id = cust_trx_id;

commit;

RETURN 'F' ;

END IF;

Exception

when others then

return NULL;

END;

below is the error i am having.

LINE/COL ERROR

-------- ----------------------------------------------------------------

328/14   PLS-00323: subprogram or cursor 'UPDATE_CUST_TRX' is declared in

a package specification and must be defined in the package body

1168/1   PL/SQL: Item ignored

1168/1   PLS-00410: duplicate fields in RECORD,TABLE or argument list are

not permitted

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值