ORA-00020 exception...urgent [message #373966] |
Fri, 18 May 2001 04:52 |
Harika
Messages: 6 Registered: May 2001
|
Junior Member |
|
|
hi everyone
when i am trying to call a stored procedure from
java i am getting the following error
can any one help
Exception :ORA-00020: maximum number of processes (250) exceeded
thanx
|
|
|
Re: ORA-00020 exception...urgent [message #373979 is a reply to message #373966] |
Fri, 18 May 2001 06:08 |
Anil Thomas
Messages: 1 Registered: May 2001
|
Junior Member |
|
|
Hi,
Check your java coding. Ensure that each database
you make through java gets closed once your
transaction is over.
Often programmers tend to overlook this. Your application keeps on making database calls and each call will open a connection. At one point of time the number of connections would exceed the database limit. So re-code and ensure your connection to the database has been closed.
Hope it helps !
Regards
Anil
|
|
|
|
|