我有一个存储过程my_procedure:每天定时执行生成一张中间表my_table,这张表里有查询一张动态表TABLE2_100323,这张动态表里的100323是每天都变化,我用下面的写法编译成功了,只是EXECUTE的时候就不行。
create or replace procedure my_procedure is
v_date varchar2(6);
begin
execute immediate 'drop table TABLE1';
execute immediate 'create table TABLE1 as
select * from newcdr.TABLE2'||v_date;
execute immediate 'drop table my_table;
execute immediate 'create table my_table as
……
select * from TABLE1
……; commit;end my_procedure;对oracle的存储过程不是非常精通,在线请教高手啊~~~
create or replace procedure my_procedure is
v_date varchar2(6);
begin
execute immediate 'drop table TABLE1';
execute immediate 'create table TABLE1 as
select * from newcdr.TABLE2'||v_date;
execute immediate 'drop table my_table;
execute immediate 'create table my_table as
……
select * from TABLE1
……; commit;end my_procedure;对oracle的存储过程不是非常精通,在线请教高手啊~~~
你的v_date,在哪给的值呢?关注中
你的v_date,在哪给的值呢?用的是此赋值语句:
select to_char(sysdate-1,'yyyymmdd') from dual已经找到问题的原因了,解决了,谢谢各位呵。