Sybrand Bakker wrote:
> On 15 Sep 2006 21:52:36 -0700, antonyliu2002_at_yahoo.com wrote:
>
> >Hi, Sybrand, thanks for your note, but I am confused by your message.
> >What do you mean by "Note execute immediate mandatory" as shown below?
> >
> > insert into foo select * from bar;
> > /* Note execute immediate mandatory!!! */
> > execute immediate 'drop table bar';
> >
> >Do you mean that "execute immediate <some sql command>" is mandatory in
> >a stored procedure?
>
>
> I didn't. I meant 'drop table ... ' *must* be wrapped in execute
> immediate. No direct DDL in stored procedures (nor anonymous blocks)
> >
> >I've been trying to schedule the job for about 2 weeks, without good
> >luck. Apparently the scheduler won't let me put all of the sql
> >commands into a single job.
> Utter nonsense. It has be shown to you several times how to do it.
>
>
>
>
> So, let me ask one question:
> >
> >Is it possible at all to schedule more than 1 jobs with Oracle
> >Scheduler and Oracle Database 10g? Yes or no? Thanks.
> This is a nonsensical question. Dbms_job, the predecessor of
> dbms_schedule, already allowed scheduling multiple jobs.
> Apart from that: you dont' *need* multiple jobs in this particular
> case, and you *shouldn't* use them is this particular case.
>
> I won't respond any further in this particular thread. Me, and others,
> have shown you the *exact* code, and still you don't get it and come
> up with nonsensical questions, showing you never opened those manuals,
> and are not prepared to do so.
> That precludes a successful Oracle career. However, that is not a
> problem with Oracle, nor is it a problem with this forum, but it is a
> problem with *YOU*. Either start reading those manuals, or go away and
> choose a different database product, as Oracle is apparently too
> difficult for you.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Hmm, an old geezer who is experiencing bad menopause. If you think
that my questions are nonsensical, simply ignore it. Why bother
barking here? Did I in any way offend you? Anyway, this is off-topic
in this forum.
Received on Sat Sep 16 2006 - 14:14:14 CDT
