Pl/Sql help...Immediate
Date: Wed, 18 Apr 2001 10:09:55 -0700
Message-ID: <9bkh3a$rao$1_at_innbox.cnet.com>
[Quoted] [Quoted] Can someone help me out on this issue? I am trying hard since yesterday but [Quoted] [Quoted] [Quoted] [Quoted] cannot make out what the mistake is...
The select statments in the code has data in it. Is everything ok on line 11 and line 12?
1 DECLARE
2 v_invoice1 varchar2(30);
3 v_amount_applied1 number;
4 v_amount_remaining number;
5 cursor c_test is
6 select INVOICE1, amount_applied1 from ar_payments_interface_all where
record_type = 4;
7 begin
8 open c_test;
9 loop
[Quoted] [Quoted] 10 fetch c_test into v_invoice1, v_amount_applied1;
[Quoted] 11 select amount_due_remaining INTO v_amount_remaining from
AR_PAYMENT_SCHEDULES_ALL
12 where trx_number = V_INVOICE1;
13 end loop;
14* end;
SQL> /
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
[Quoted] ORA-06512: at line 11
Appreciate your help
Thanks
Srikanth
Received on Wed Apr 18 2001 - 19:09:55 CEST