Re: triggers, db jobs, & raising errors

The conventional meaning of "batch job" is that this is a background task, so you are NOT intererested in when the batch job completes. It is a background task, you want it to be done, but you want to proceed with your own work.
You seem to be trying a 'batch job' as part of an ordinary transaction. That's not going to work. Your 'batch job' would need to communicate with foreground process with dbms_pipe and/or the aq facility. You will end up with many job queues and batch jobs preventing other batch jobs to run.

That said, the description of your problem is just to be vague to be adressed properly. I can only shiver with 'trying to achieve some degree of parallelism in processes (vs. in a
> single query).'

as it sounds like you want to re-invent parallel query available in the Enterprise Edition. Even if you do not want to re-invent that: I once was involved in a project where the original developer designed it's own interprocess communication mechanism in a 3GL language (as opposed to assembler or C) because the (version of) the O/S we were using didn't have that facility.
Unfortunately , as it has been written in 3GL and was too slow, we never got it working properly.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address



"Neal Helman" <nhelman_at_peakpeak.com> wrote in message
news:3d54a14b$1_at_news.peakpeak.com...


> So would there be another method for calling a stored procedure from

another


> stored procedure such that the caller continues while the other runs?  We

> were trying to achieve some degree of parallelism in processes (vs. in a

> single query).  Is there some distinction between a "batch job" and a

> "stored procedure" that I'm missing, other than that the latter

necessarily


> resides in the database?

>

> Thanks,

> Neal

>

> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message

> news:oai6luc116v1siv6au6hu6kmemtco7c7rn_at_4ax.com...

> > On Thu, 08 Aug 2002 21:22:23 GMT, "Neal Helman" <nhelman_at_peakpeak.com>

> > wrote:

> >

> > >I realize that the job is probably running under a background process,

> but

> > >isn't there some sort of connection between the calling connection and

> that

> > >background process?

> >

> > There isn't. Why should it? Basically you run batch jobs through

> > dbms_job.

> > You are misusing the dbms_job facility for purposes it wasn't designed

> > for.

> >

> > Regards

> >

> >

> > Sybrand Bakker, Senior Oracle DBA

> >

> > To reply remove -verwijderdit from my e-mail address

>

>