dbms_job not running at sqlplus shell

[Quoted] I'm trying to run dbms_job at sqlplus shell but failed. In Toad i managed to run this at "Editor"->"Execute statement"

exec dbms_job.isubmit(1234, 'TEST;',SYSDATE,INTERVAL => 'SYSDATE+(2/24/60)');
/

successfully

But when i run

    [abc]$ sqlplus user/password _at_compile1.sql

    compile1.sql's content
    spool compile.log;
    _at_try.sql
    spool off;

try.sql's content

exec dbms_job.isubmit(1234, 'TEST;',SYSDATE,INTERVAL => 'SYSDATE+(2/24/60)');
/

after runnning compile1.sql, this appears

[abc]$ sqlplus ESERV/ESERV _at_compile1.sql

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 28 13:46:11 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

and it stucked there forever. I did try to include begin ... end;

but still it doesn't succeed , kindly advise if you have any idea, thanks !

regards, Tan Received on Thu Mar 27 2014 - 04:44:10 CET