Problem running Oracle stored procedure in Java - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

Problem running Oracle stored procedure in Java

Problem running Oracle stored procedure in Java# Java - 爪哇娇娃

y*o2007-05-23 07:05

1 楼

I have never tried stored procedure in Java. So, I would like to give it a
shot.
I got the demo from Oracle and compiled this one: PLSQL.java, which is
attached in this post. This code uses Oracle XE's hr/hr schema. I've tried
some other code with plain SQL, and it runs just fine and returns employee
info from the employees table.
But, when I run this PLSQL, I get the following error, and I don't know what
it means. It looks like I get such error message for all codes involving
stored proced

y*o2007-05-23 07:05

2 楼

Seems a lot of people are having this problem. Is this a bug? I haven't se
en a solution yet.

a
tried
employee
what

【在 y********o 的大作中提到】

: I have never tried stored procedure in Java. So, I would like to give it a
: shot.
: I got the demo from Oracle and compiled this one: PLSQL.java, which is
: attached in this post. This code uses Oracle XE's hr/hr schema. I've tried
: some other code with plain SQL, and it runs just fine and returns employee
: info from the employees table.
: But, when I run this PLSQL, I get the following error, and I don't know what
: it means. It looks like I get such error message for all codes involving
: stored proced

y*o2007-05-23 07:05

3 楼

我来继续自说自话。
JavaRanch 的 Gaurav Chikara 说：

Generally this exception comes when heap memory exceeeds to that what JVM ca
n handle.
You must try setting heap memory to greater value using xmx ,xms variables i
n your Environment file