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: dbms_job and "ORA-03113: end-of-file on communication channel"

Re: dbms_job and "ORA-03113: end-of-file on communication channel"

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 30 Apr 2004 21:37:26 -0700
Message-ID: <1083386243.147711@yasure>


John Heinrich wrote:

> ORA-03113 after job execution
>
> I have to users, eg. user1 and user2
>
> From an ASP web application a procedure (eg. proc1, owned by user1) is
> being called by user2. Proc1 is putting a job in the queue and the
> running it (eg. proc2 owned by user1).
> Proc2 is inserting a record in a tabel on a different database through
> a db-link.
>
> Create procedure proc1(param1 in varchar2, pCursor out Cursor) is
> jobno number;
> BEGIN
> some sql-strings is generated.
> if blah_1 then
> BEGIN
> -- inserting a record in a log table
> dbms_job.submit(jobno,proc2(param1),sysdate);
> dbms_job.run(jobno);
> EXCEPTION
> when others then
> shit happens!
> END;
> end if;
> if blah_2 then
> BEGIN
> -- inserting another record in another log table
> dbms_job.submit(jobno,proc2(param2),sysdate);
> dbms_job.run(jobno);
> EXCEPTION
> when others then
> shit happens!
> END;
> end if;
> open cursor for "the generated sql-string"
> EXCEPTION
> when others then
> shit happens!
> END;
>
> When I run the procedure from a sql prompt as user2 it just works
> fine.
> When I run it from ASP as user2, and only the first jobs is generated
> and runned, it just works fine, but if both jobs is submitted and
> runned then the ASP receives an ora-error: "ORA-03113: end-of-file on
> communication channel".
> (both jobs is actually executed and the records is inserted on the
> other the database).
>
> What is happening?

Does your Oracle have a version and edition? Does it run on any hardware?
Is there an operating system?
If *NIX have you verified the kernel parameters?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Apr 30 2004 - 23:37:26 CDT

Original text of this message

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