Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger Fail in Job execution

Re: Trigger Fail in Job execution

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 11 Jul 2002 13:52:45 +1000
Message-ID: <agivd2$url$1@lust.ihug.co.nz>


IT WAS A METAPHOR!!! Honestly! The way people's minds work, it buggers belief.

Regards
HJR "Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:Ck6X8.32579$Hj3.97651_at_newsfeeds.bigpond.com...
> I'm a visual person so when I first read this, I gasped and recoiled in
> horror at the image in my mind.
>
> As I recovered the only thought that crossed my mind was, for the sheep's
> sake, thank goodness it was dead !!
>
> Richard
> "Pete Sharman" <peter.sharman_at_oracle.com> wrote in message
> news:aghn63011n2_at_drn.newsguy.com...
> > In article <aghcl6$dhv$1_at_lust.ihug.co.nz>, "Howard says...
> > >
> > >Not really.
> > >
> > >The only tip I have, in all seriousness, is that I would sooner shag a
> dead
> > >sheep than use 8.1.5. Like the sheep, it is riddled with bugs. You need
> to
> > >upgrade to something supported. Like 8.1.7.
> > >
> > >Regards
> > >HJR
> >
> > Damn you get around down there! First we find you and Richard are
> Tasmanian,
> > now we find you also have New Zealand ancestry! ;)
> >
> > Pete
> > >
> > >"Homero Fonseca" <hjsfonseca_at_yahoo.com.br> wrote in message
> > >news:6f277867.0207100514.55212983_at_posting.google.com...
> > >> Hi!
> > >>
> > >> I have Oracle 8.1.5 in my company, and I have some jobs which execute
> > >> some tasks overnight. Recently I got a problem in execution of a job,
> > >> that needs to insert some lines in a table, and update other table by
> > >> trigger (on first table).
> > >> The update must be applied by trigger, but it don't occurs when the
> > >> job is executed by SNP Process Background.
> > >> I try to force execute the job, and the update occurs. But when I
> > >> schedule the job to execute overnight, the update fails.
> > >> Curiously, the rest of the procedure(schedulled in job) is executed.
> > >> Only the update, in trigger, don't occurs.
> > >> A log was created to give me some information, and I saw the
procedure
> > >> executing without any exceptions or errors. Only the update fails.
> > >> Someone could send any tip to help discover what is happening on this
> > >> procedure?
> > >>
> > >> Thanks,
> > >> Homero Fonseca.
> > >
> > >
> >
> > HTH. Additions and corrections welcome.
> >
> > Pete
> >
> > SELECT standard_disclaimer, witty_remark FROM company_requirements;
> >
>
>
Received on Wed Jul 10 2002 - 22:52:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US