Home » SQL & PL/SQL » SQL & PL/SQL » urgent
urgent [message #35862] Fri, 19 October 2001 11:32 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
monish
Messages: 2
Registered: October 2001
Junior Member
Thanks Milan

----------------------------------------------------------------------
Previous Topic: Time Isolation and Setting
Next Topic: Capture Feedback in Procedure
Goto Forum:
  


Current Time: Fri Apr 03 06:47:00 CDT 2020