我有一个update语句:
EXEC SQL update taccorequest a set a.d_cdate=to_date('20080813','yyyymmdd'),
a.c_status='6',a.c_cause='7621申请日期无效'
where nvl(trim(a.c_status),'0')='0'
and nvl(a.c_nodealflag,'0')='0'
and nvl(a.c_taflag,'0')='0'
and trunc(a.d_date)<>trunc(a.d_requestdate)
and (a.d_requestdate<=to_data('20080811','yyyymmdd') or a.d_requestdate>to_date('20080813','yyyymmdd'));
如果单独把后面的update拿处理在pl/sql里执行没有问题,但是在proc中执行是,就会报ora-0933:command not properly ended
各位大虾,请问这是怎么回事呢?

最新回复
onling2 (2008-8-15 10:02:21)
redneck_he (2008-8-15 10:35:12)
genomics (2008-8-15 14:30:32)