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