Executing Oracle stored procedure from a Java stored procedure

[Alain ROUILLON]

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

[Jim Harrington]

Dan,

Apparently Alain got sidetracked, but I'm seeing exactly the same
situation. Here are my answers to your questions:

1) RS6000 - 4GB
2) AIX 4.3.3 maintenance level 10
3) 9.2.0.3
4) java shared pool 150M, shared pool 200M
5) 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@x.washington.edu> wrote in message news:<1073396295.988854@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?

[Daniel Morgan]

Jim Harrington wrote:
Dan, Apparently Alain got sidetracked, but I'm seeing exactly the same situation. Here are my answers to your questions: 1) RS6000 - 4GB 2) AIX 4.3.3 maintenance level 10 3) 9.2.0.3 4) java shared pool 150M, shared pool 200M 5) 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.

Well I I might as well announce I have a broken leg so my ability to
function, given a fair dosage of opiates in my bloodstream is somewhat
altered. With that caveat I'd suggest that you, or someone here in the
group look for bugs on metalink. Because nothing jumps out at me
immediately other than suggesting that you patch to 9.2.0.4.

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)