DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: exception help

  1. #1
    Join Date
    Nov 1999
    Posts
    226

    Angry

    declare
    a number ;
    b number ;
    x number ;
    y number ;
    c number ;
    d date ;
    z date ;
    begin
    a := 1;
    b := a+1;
    select shrfnbr into x from puneet_temp where serial = a;
    select trunc(timestamp) into d from puneet_temp where serial = a;
    select shrfnbr into y from puneet_temp where serial = b;
    c:= y-x;
    loop
    select trunc(shrstmp) into z from shopper where shrfnbr =c;
    if z <> d then
    dbms_output.put_line ( c || ' ' || z);
    end if;
    exit when c < 8520 ;
    c:=c-1;
    end loop;
    exception when no_data_found then
    dbms_output.put_line ( c || ' ' || 'NODATA');
    end;
    /

  2. #2
    Join Date
    Aug 2000
    Posts
    462
    check your DBA thread on this subject

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width