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

Thread: Pls-00103:

  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Pls-00103:

    Dear All,,
    I am trying to execute this procedure to get populated date
    and iam getting Error PLS-00103: ,, HELP


    ----
    create or replace procedure dt_update (vdt1 IN date, vdt2 IN date, vdate OUT date)
    IS
    vdt1 := &dt1;
    vdt2 := &dt2;
    begin
    while vdt1 <= vdt2
    dbms_output.put_line('Enter Starting Date Range:' || vdt1);
    loop
    vdate=vdt1+1;
    exit when vdate=vdt2;
    end loop;
    dbms_output.put_line('Populated Date is:' || vdate);
    end;
    /

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    get rid of these lines

    vdt1 := &dt1;
    vdt2 := &dt2;

    you also haven't declared vdate anywhere

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