最近编写一个存储过程发现如下错误:
ORA-06550: line 1, column 7: PLS-00905: object SZXFJF.update_flag is invalid
ORA-06550: line 1, column 7: PL/SQL: Statement ignored
ORA-06550: line 1, column 7: PL/SQL: Statement ignored
create or replace procedure update_flag
(date_f in dz_resultfromboss_dz_tmp.SCPDATEANDTIME%type, --错误1、库中不存在此表
date_l in dz_resultfromboss_dz_tmp.SCPDATEANDTIME%type)
is
begin
drop table dz_resultfromboss_dz_tmp; --错误2、执行sql语句时候需要使用 execute immediate 'drop table dz_resultfromboss_dz_tmp';
(date_f in dz_resultfromboss_dz_tmp.SCPDATEANDTIME%type, --错误1、库中不存在此表
date_l in dz_resultfromboss_dz_tmp.SCPDATEANDTIME%type)
is
begin
drop table dz_resultfromboss_dz_tmp; --错误2、执行sql语句时候需要使用 execute immediate 'drop table dz_resultfromboss_dz_tmp';
dbms_ou