Xref: alice comp.databases.oracle.server:83038
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.stanford.edu!logbridge.uoregon.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: Frederic Bidon <fbi@mobilix.dk>
Newsgroups: comp.databases.oracle.server
Subject: RE: easy rdbms_job.submit question
Date: Wed, 2 Feb 2000 14:50:38 +0100
Organization: Deja.com - Before you buy
Lines: 106
Message-ID: <2D3005375CAED31199D00008C784963F02097D@ms02.mobilix.dk>
Mime-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
To: "'comp.databases.oracle.server@list.deja.com'"
	 <comp.databases.oracle.server@list.deja.com>
Cc: "'Martin Haltmayer'" <martin.haltmayer@0800-einwahl.de>
X-Mailer: Internet Mail Service (5.5.2448.0)
X-DejaID: _xiz/AIPid6wYQ9xEe5VrVUICVXGpKI/T?=

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@0800-einwahl.de]
Sent: 26. januar 2000 12:58
To: comp.databases.oracle.server@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@hotmail.com [mailto:elee3@hotmail.com]
> Sent: 20. januar 2000 22:51
> To: comp.databases.oracle.server@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.




 _____________________________________________________________
 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/%3C388EE158.3CF6E1C4%400800-einwahl.de%3E


 Sent via Deja.com http://www.deja.com/
 Before you buy.