Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Trying to run a dbms_run on an external file
Try the kitchen sink or read the manual: you can submit pl/sql procedures
*only*.
If you want to run a sql script as a job, use the at command or the job
facility in OEM.
Regards,
Sybrand Bakker, Oracle DBA
"Michael D. McGrath" <mcgrathmd_at_emtsolutions.com> wrote in message
news:sms1ghuind6183_at_corp.supernews.com...
> I am trying to run an external SQL file as a job in sqlplus. I have tried
> everything but the kitchen sink. At the prompt I can type:
>
> SQL> @test.sql;
>
> Everthing is fine, but I cannot run a job on the same file.
>
> variable Job_no number;
> begin
> dbms_job.submit(:job_no,'@test.sql;',sysdate,'sysdate +
> (10/(24*60*60))');
> end;
> /
>
> and I have tried
>
> variable Job_no number;
> begin
> dbms_job.submit(:job_no,'@test.sql',sysdate,'sysdate +
> (10/(24*60*60))');
> end;
> /
>
> I get errors on both.
>
> Can anyone help????
>
> Thnks in advance.....
>
> Mike McGrath
>
> mcgrathmd_at_emtsolutions.com
>
>
>
>
>
Received on Thu Jul 13 2000 - 00:00:00 CDT