Strange. (please help : urgent) [message #38944] |
Wed, 29 May 2002 20:42 |
diaz
Messages: 58 Registered: October 2001
|
Member |
|
|
Hi,
Please help me out here..
I have this code..
I don't know what's wrong with this query..
why does it not giving any result
while trying it on the sql*plus .. the result appears!
please... please.. help
declare
thiseop varchar(6):='200110';
idpayment number(9);
begin
dbms_output.put_line ('abc');
select distinct(parent_payid) into idpayment from payment
where msisdn='811100115' and to_char(paydate,'YYYYMM')=thiseop;
dbms_output.put_line ('def');
dbms_output.put_line (idpayment);
exception
when no_data_found then
dbms_output.put_line ('xyz');
when others then
dbms_output.put_line (sqlerrm);
end;
the idpayment neither the sqlerror won't appear...!
please.. help me
|
|
|
|