SQL window中执行以下语句:
select begintime ,num from table1 order by begintime desc;
结果:
BEGINTIME NUM
2009-8-3 13:24:30 1
2009-8-2 13:21:00 2
2009-8-1 13:17:30 3
...
delete rounds where >=begintime(select begintime from table1 where num=3);
删除成功;
问题:
在存储过程中:
create or replace procedure myprc( p_num in number) is
begin
delete rounds where >=begintime(select begintime from table1 where num=p_num);
*问题1:我test测试下执行不过去,会一直卡在这是为什么呢,也不报错
end myprc;分成两句执行:
create or replace procedure myprc( p_num in number) is
begin
v_begin_time date;
select begintime into v_begin_time from table1 where num=p_num;
delete rounds where begintime >=v_begin_time and num=p_num;//会卡在这一句执行不了,也不报错
dbms_output.put_line(v_begin_time);
//output 结果:01-8月 -09 (*问题2:这里的输出时间怎么和PLSQ中select出来的的时间格式怎么不一样)
end myprc;
select begintime ,num from table1 order by begintime desc;
结果:
BEGINTIME NUM
2009-8-3 13:24:30 1
2009-8-2 13:21:00 2
2009-8-1 13:17:30 3
...
delete rounds where >=begintime(select begintime from table1 where num=3);
删除成功;
问题:
在存储过程中:
create or replace procedure myprc( p_num in number) is
begin
delete rounds where >=begintime(select begintime from table1 where num=p_num);
*问题1:我test测试下执行不过去,会一直卡在这是为什么呢,也不报错
end myprc;分成两句执行:
create or replace procedure myprc( p_num in number) is
begin
v_begin_time date;
select begintime into v_begin_time from table1 where num=p_num;
delete rounds where begintime >=v_begin_time and num=p_num;//会卡在这一句执行不了,也不报错
dbms_output.put_line(v_begin_time);
//output 结果:01-8月 -09 (*问题2:这里的输出时间怎么和PLSQ中select出来的的时间格式怎么不一样)
end myprc;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货