| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> RE: easy rdbms_job.submit question
You are definitely right. I focused so much on the wrong syntax Elizabeth
gave us that I didn't even notice that it was a file in the argument ! Of
course it is not possible, no question about that.
Since, executing an external procedure is an interesting issue, and it can
be done through a java call I think (8i).
Frederic.
-----Original Message-----
From: Martin Haltmayer [mailto:martin.haltmayer_at_0800-einwahl.de]
Sent: 26. januar 2000 12:58
To: comp.databases.oracle.server_at_list.deja.com
Subject: Re: easy rdbms_job.submit question
Message from the Deja.com forum:
comp.databases.oracle.server
Your subscription is set to individual email delivery
I guess that this will not work. The "what" parameter (#2) must be the name of a PL/SQL procedure, not the name of a script file! Maybe you can run your script with Intelligent Agent but definitely not by DBMS_JOB.SUBMIT! Martin
Frederic Bidon wrote:
>
> Hi Zbeth,
> It seems that they're some missing parts in your understanding of PL/SQL.
> But the best way to learn is to try, and try again.
> Try this, I always do it like that (in an anonymous PL/SQL block) :
>
> DECLARE
> job INTEGER;
> no_parse BOOLEAN:=TRUE;
> BEGIN
> DBMS_JOB.SUBMIT
> (job,
> 'E:\ORANT\RDBMS\BACKUP\LXODBACKUP.SQL',
> sysdate,
> 'SYSDATE+1',
> no_parse)
> END;
> / (/ in SQL*PLus of course)
>
> For other PL/SQL questions, purchase the excellent Oracle PL/SQL
> programming from Oracle Press by Scott Urman, and visit www.revealnet.com
> where there is a PL/SQL pileline chat and some other good advices from
Steve
> Feuerstein, a PL/SQL guru.
>
> Frederic.
>
> -----Original Message-----
> From: elee3_at_hotmail.com [mailto:elee3_at_hotmail.com]
> Sent: 20. januar 2000 22:51
> To: comp.databases.oracle.server_at_list.deja.com
> Subject: easy rdbms_job.submit question
>
> Message from the Deja.com forum:
> comp.databases.oracle.server
> Your subscription is set to individual email delivery
>
> This is a backup script job. What is wrong with this syntax?
>
> PROCEDURE DBMS_JOB.SUBMIT
> (job OUT BINARY_INTEGER,
> 'E:\ORANT\RDBMS\BACKUP\LXODBACKUP.SQL' IN VARCHAR2,
> sysdate,
> 1,
> no_parse)
>
> Thanks,
> Elizabeth
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
> _____________________________________________________________
> Deja.com: Before you buy.
> http://www.deja.com/
> * To modify or remove your subscription, go to
> http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
> * Read this thread at
> http://www.deja.com/thread/%3C867vv3%24or9%241%40nnrp1.deja.com%3E
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Sent via Deja.com http://www.deja.com/ Before you buy. Received on Wed Feb 02 2000 - 07:50:38 CST
 |
 |