-
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;
/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|