urgent [message #35862] |
Fri, 19 October 2001 11:32 |
monish
Messages: 2 Registered: October 2001
|
Junior Member |
|
|
Hi,
I have cursor to retreive multiple rows,
in my stored procedure,
but whats happening is, when i run the stored procedure
first iam getting 2 rows which is correct, but if i execute it one more time iam getting 4 rows, its keep
increasing by 2, please can any one help me
----------------------------------------------------------------------
|
|
|
Re: urgent [message #35865 is a reply to message #35862] |
Fri, 19 October 2001 12:41 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
its strange error. could you post exact code?. so that somebody can help you
----------------------------------------------------------------------
|
|
|
Re: urgent [message #35869 is a reply to message #35862] |
Sat, 20 October 2001 04:42 |
Milan Kumar Barui
Messages: 16 Registered: October 2001
|
Junior Member |
|
|
Hi Manish,
You can try with this command.
Login as system
and execute:
alter system flush shared_pool;
I think it will solve your problem.
Thanks
Milan
Oracle DBA
----------------------------------------------------------------------
|
|
|
Re: urgent [message #35883 is a reply to message #35862] |
Mon, 22 October 2001 05:35 |
monish
Messages: 2 Registered: October 2001
|
Junior Member |
|
|
Thanks Milan
----------------------------------------------------------------------
|
|
|