create or replace procedure Test_GetOaUserInfo as
--authid current_user操作当前存储过程的当前用户,否则提示权限不足,但是这样存储过程这能执行一次
--,或者GRANT CREATE ANY TABLE TO any users;
timePoint Date;
tabCstr varchar2(1000); --创建表的字符串
varNum number(1) default 0; --定义统计记录变量默认为0
tabDstr varchar2(500); --存数据的字符串
tabData varchar2(500); -- 存数据的字符串
maxRow number;
begin
--抓取截止日期
select max(last_date) into timePoint from basedb_users;
--存取表的记录数
select count(*) into varNum from user_tables where table_name='BASEDB_USERS_TEMP_TB';
if timePoint is null then
begin
timePoint:=sysdate;
end;
end if;
dbms_output.put_line(to_char(timePoint,'YYYY-mm-dd hh24:mm:ss')); --set serveroutput on
dbms_output.put_line(varNum);
--创建临时表
if varNum < to_number(1) then --如