How to solve recursive SQL level string Problem

Hello sir

I am Using One Jsp Page That Page Fetch The all Details But some Times Show half Of The Details Only at The Time These Errors Fired.

1)ORA-00604: error occurred at recursive SQL level string
2)ORA-00018:maximum number of sessions exceeded.

I click The Refresh Then Show to All Details

which server you are using? if you are using Oracle Application Server then i guess restart your OC4J.

Hi

I am Using simply JBoss Application Server 4.0.2 Database oracle 10g

"vinay chk",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
JavaRanch Sheriff

Can you post the code snippet, dealing with DB?

Please have a look

http://www.orafaq.com/forum/t/21841/2/

this will help you .

Originally posted by Nikhil Goel:
Please have a look

http://www.orafaq.com/forum/t/21841/2/

this will help you .

After looking to your code, I got to know that it is nothing to do with JSP. You would, hopefully, get some help in JDBC Forum.

Thanks.

After going through few searches I got to know that its difficult to find the solution over the net.

You can try the same code, or something similar, on some other Oracle DB.

Wish you all the best.