Re: dbms_job

In article <1156810269.022526.171550_at_m73g2000cwd.googlegroups.com>, rjgst3 says...
> I'm fairly new as creating dbms_job but I feel that what I'm trying to
> do is fairly simple. Heres what I have:
>
> VARIABLE b_job number
>
> BEGIN
> DBMS_JOB.SUBMIT(JOB => :b_job,
> WHAT => 'insert into tbl select * from test_data;',
> NEXT_DATE => sysdate,
> INTERVAL => 'sysdate+1');
> COMMIT;
> End
>
> This will not commit, and I get an 'Invalid Sql'. Granted, the sql in
> the example is genric, I confirmed 3 times that the insert sql
> statement is correct.....Any help/ideas?
>
>

I don't think I have ever seen an "Invalid SQL" - is there perchance an error number also listed?

Your final END needs a ;

-- 
jeremy