Re: Executing Oracle stored procedure from a Java stored procedure
Date: 12 Jan 2004 13:55:54 -0800
Message-ID: <cc3ae75b.0401121355.3d15fc3c_at_posting.google.com>
Dan,
[Quoted] Apparently Alain got sidetracked, but I'm seeing exactly the same situation. Here are my answers to your questions:
- RS6000 - 4GB
- AIX 4.3.3 maintenance level 10
- 9.2.0.3
- java shared pool 150M, shared pool 200M
- N/A
In our case, we have a java based function that calls a PL/SQL stored procedure that opens up a number of cursors. The java function consumes all the cursors, puting the resulting data into HashMaps that are then serialized and the resulting byte[] returned by the java function as a BLOB.
When the logic that the java functions is executed outside of the database, about 2.5MB of memory is used. This leads us to believe that it is unlikely that we are exceeding the 150MB we have in the java shared pool. When we run, the database connection cores and leaves a trace file. We have found that if we trim down the select clauses of the queries made in the PL/SQL procedure, we can cause the overall call to succeed.
Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1073396295.988854_at_yasure>...
> Alain ROUILLON wrote:
> > Hi,
> >
> > Here is my pb :
> >
> > Executing an Oracle stored procedure from a Java method included within a
> > Java class stored on the Oracle database causes an error ORA-03113
> > "End of file on communication canal".
> >
> > When executing the Java method straight from a command line everything is
> > ok. If executed from the Oracle server, I get this message.
> >
> > I need your help !
> >
> > Alain
>
> Oh how I get tired of this!
>
> 1. What hardware platform with how much RAM?
> 2. What operating system and version?
> 3. What Oracle version and edition?
> 4. What is the size of the Java Shared Pool?
> 5. If Solaris or HP/UX are the kernel parameters for shared memory and
> semaphores those recommended by Oracle for your operating system and the
> number of processes?
>
> Who do so many people think their problems exist in a vacuum?
Received on Mon Jan 12 2004 - 22:55:54 CET