PL/SQL 存储过程出错
答案:2 悬赏:10 手机版
解决时间 2021-01-07 13:10
- 提问者网友:轮囘Li巡影
- 2021-01-07 04:56
PL/SQL 存储过程出错
最佳答案
- 五星知识达人网友:老鼠爱大米
- 2021-01-07 05:26
我试验了,你的代码写的大体没有错误,只有一点点问题。
改成下面这样后,在我的电脑上过了,你试试吧。
update index_check_log cc
set cc.diff_time = to_date(v_ft - v_bt)
where cc.id_log = r1.id_log;
***********
试试log:
***********
[TEST@ORA1] SQL>create or replace procedure p_index_check is
2 v_sql varchar2(2048);
3 v_bt timestamp;
4 v_ft timestamp;
5 cursor c1 is select * from index_check_log;
6 Begin
7 for rr in c1 loop
8 v_sql := rr.sql_statement;
9 update index_check_log aa
10 set aa.v_begin_time = (to_char(systimestamp, 'yyyy-mm-dd hh24:mi:ssxff'))
11 where aa.id_log = rr.id_log;
12
13 v_bt := systimestamp;
14 execute immediate v_sql;
15 v_ft := systimestamp;
16 update index_check_log bb
17 set bb.v_finish_time = (to_char(systimestamp, 'yyyy-mm-dd hh24:mi:ssxff'))
18 where bb.id_log = rr.id_log;
19
20 update index_check_log cc
21 set cc.diff_time = to_date(v_ft - v_bt)
22 where cc.id_log = rr.id_log;
23 End loop;
24 End;
25 /
Procedure created.
---
以上,希望对你有所帮助。
改成下面这样后,在我的电脑上过了,你试试吧。
update index_check_log cc
set cc.diff_time = to_date(v_ft - v_bt)
where cc.id_log = r1.id_log;
***********
试试log:
***********
[TEST@ORA1] SQL>create or replace procedure p_index_check is
2 v_sql varchar2(2048);
3 v_bt timestamp;
4 v_ft timestamp;
5 cursor c1 is select * from index_check_log;
6 Begin
7 for rr in c1 loop
8 v_sql := rr.sql_statement;
9 update index_check_log aa
10 set aa.v_begin_time = (to_char(systimestamp, 'yyyy-mm-dd hh24:mi:ssxff'))
11 where aa.id_log = rr.id_log;
12
13 v_bt := systimestamp;
14 execute immediate v_sql;
15 v_ft := systimestamp;
16 update index_check_log bb
17 set bb.v_finish_time = (to_char(systimestamp, 'yyyy-mm-dd hh24:mi:ssxff'))
18 where bb.id_log = rr.id_log;
19
20 update index_check_log cc
21 set cc.diff_time = to_date(v_ft - v_bt)
22 where cc.id_log = rr.id_log;
23 End loop;
24 End;
25 /
Procedure created.
---
以上,希望对你有所帮助。
全部回答
- 1楼网友:举杯邀酒敬孤独
- 2021-01-07 07:03
13及就是 13及 牛比啊 select 没into在存储过程里竟然还能跑 .....赞一个
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯