Hello Community
I have the following Query and I Can Not Get the Syntax to Validate.
My Question is the positioning of the "Into Variables"
select rl.receipt_amount - nvl(rl.postage,0)
,
(select abs(nvl(sum(rl.receipt_amount),0))
from receipt_log rl
where rl.refunded_receipt_log_id = :P64_RECEIPT_LOG_ID )
into v_receipt_amt
,
into v_rl_refunded_amt
from receipt_log rl
where rl.receipt_log_id = :P64_RECEIPT_LOG_ID;
Getting Following Error
ORA-06550: line 27, column 10: PL/SQL: ORA-00936: missing expression ORA-06550: line 20, column 9: PL/SQL: SQL Statement ignored