I am facing a issue while calling a stored procedure using execute stored proced

sunnya527

A Score Level 2

over 10 years ago

I am facing a issue while calling a stored procedure using execute stored procedure smart service.
It is giving me an alert as
There is a problem with task “xxxxx" in the process “yyyyyy”. [An error occured: $ORA-01000: maximum open cursors exceeded ORA-06512: at line 22 ]

any idea on this ?

Discussion posts and replies are publicly visible

Parents

0 Umesh Patel over 10 years ago

Hi Tim, if this issue is occurring frequently than its not good to restart application server every time. Is there any pointer where problem can exists? If we analyse the scenario which Sunny has mentioned, following comes into picture:
1. Smart Service
2. Stored Procedure in DB.
where this leak can be?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Umesh Patel over 10 years ago

Hi Tim, if this issue is occurring frequently than its not good to restart application server every time. Is there any pointer where problem can exists? If we analyse the scenario which Sunny has mentioned, following comes into picture:
1. Smart Service
2. Stored Procedure in DB.
where this leak can be?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data