有如下匿名塊：在查詢分析器中執行成功！
但用sqlComm.ExecuteNonQuery()執行卻顯示失敗！，有知道的大俠們，告訴我一下原因，謝謝！
declare
  newid decimal;
begin
  insert into trs_jobm
    (job_name, job_type, begin_time, add_user, add_time)
  values
    ('測試Job3', 'w', '10:11', 1721, sysdate)
  returning job_id into newid;
  insert into trs_job_week
    (job_id, weeks, run_weeks)
  values
    (newid, 1, '1,2');
  insert into trs_job_advanced
    (job_id, begin_date, end_date, is_repeat, times, unit, end_time)
  values
    (newid, '20110316', '', 'Y', 25, 'M', '10:11');
  commit;
exception
  when others then
    rollback;
    raise_application_error(-20009, sqlerrm);
end;