EXECUTE IMMEDIATE giving error in Oracle 9i [message #8655] |
Wed, 17 September 2003 05:05 |
Radhika
Messages: 12 Registered: June 2001
|
Junior Member |
|
|
hi! I am get the following error when i use 'EXECUTE IMMEDIATE' in my PL/SQL block:
ERROR at line 1:
ORA-00907: missing right parenthesis
ORA-06512: at line 28
my PL/SQL block snippet is as under:
partition_name_last varchar(30);
partition_name_1 varchar(30);
partition_name_2 varchar(30);
num_of_split number(5) := 10;
partition_name_prefix varchar(30);
while(tmp_count < num_of_split)
loop/***this is line number 28***/
execute immediate 'alter table detailedcdr split partition '||partition_name_1||' at ('||temp_next_part_date||') into
(partition '||partition_name_1||' tablespace USERS,partition '||partition_name_2||' tablespace USERS)';
dbms_output.put_line('part_num : '||to_char(part_num)||' temp_next_part_date : '||
to_char(temp_next_part_date,'yyyy-mm-dd hh24:mi:ss')||partition_name_1 || ' '||partition_name_2);
part_num := part_num + 1 ;
temp_next_part_date := temp_next_part_date + (1/6);
partition_name_1 := partition_name_prefix||to_char(part_num);
partition_name_2 := partition_name_prefix||to_char(part_num+1);
tmp_count := tmp_count + 1;
end loop;
If someone can figure out what the problem is, then please let me know. Thank you in advance
Regards,
Radhika Mehta
|
|
|