How to automatically add partitions in a stored procedure

Declare  V_ SQL  Varchar2 ( 1000  ); Table_name  Varchar2 ( 100  ); I _day  Varchar2 ( 8 ): =   '  20120611  '  ; I _l_day Varchar2 ( 8  );  Begin  I _l_day:  = To_char (to_date (I _day, '  Yyyymmdd  ' ) +   1 ), '  Yyyymmdd  '  ); Table_name: =   Upper ( '  Table Name  '  ); V_ SQL:  =   '  ALTER TABLE  '   |   '   '   | Table_name |   '   '  |                  '  Add Partition  '   |   '   '   |   '  Part _  '   | I _day |   '   '   |                  '  Values less ( '''   | I _l_day |   '''  )  '  ; Dbms_output.put_line (v_ SQL );  End ;

In this way, partitions are automatically created by day. It can also be written as a process, which is good for every call.