在TOAD中执行procedure出错！
做了个存储过程proc_run，在GOLDN在用exec proc_run执行没问题；而在TOAD的JOBS中执行就出错：
ORA-12011 execution of num jobs failed
Cause: Some kind of error was caught in DBMS_IJOB.RUN. One or more jobs that were due to be run produced errors that they could not handle.
Action: Look at the alert log for details on which jobs failed and why.
Copyright (C) 1995, Oracle Corporation
-------------------------------------------------------
procedure proc_run
is
sdate VARCHAR2(10);
edate VARCHAR2(10);
ldate date;
begin
ldate:= '3/20/2006';--●●如果没有这句就不会出错！
.................
..................
===========================================
这是什么原因？？？
问题点数：50、回复次数：3Top
1 楼derris（深水鱼）回复于 2006-05-02 20:35:53 得分 25
ldate:= '3/20/2006';
ldate:= to_date('3/20/2006', 'mm/dd/yyyy');
这句应该都报告错误的，除非你在后面把exception给Null了。Top
2 楼XIAOLANFANG（）回复于 2006-05-02 20:45:53 得分 25
在oracle中,日期表示要用 to_date,
"......could not handle"你给异常处理一下Top
3 楼wgh166（涌金水牛）回复于 2006-05-04 19:49:51 得分 0
为什么?Top
