wgpling的专栏

  PROCEDURE xp_WriteFile(da_tel  varchar2,                         dt_bh   varchar2,                         dt_da   varchar2,                         dt_date date) as        fno utl_file.file_type;  

1、在oracle的 Java sources里面创建如下java程序 create or replace and compile java source named senddate aspackage org.bromon.oracle;public class SendDate{  public static void Send(String da_tel,String dt_bh,

<br />ORA-01008: 并非所有变量都已绑定<br /><br />是因为多了个冒号":"， 把sys.dbms_job.submit(job => :job,冒号去掉。<br /> <br /> <br />DECLARE job NUMBER;<br />begin<br /> sys.dbms_job.submit(job => job,<br /> what => 'PK_JOBS.cutMoAction;',<br />