Home » SQL & PL/SQL » SQL & PL/SQL » doubt in cursor
doubt in cursor [message #200669] Tue, 31 October 2006 19:03 Go to next message
dream17
Messages: 2
Registered: October 2006
Junior Member
hi,
i have to call multiple cursors in a procedure.there are some procedure variables.how can i set table values to procedure variables thru cursor?PLease help
Re: doubt in cursor [message #200673 is a reply to message #200669] Tue, 31 October 2006 20:32 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
I want to build a car. I have some gears & bolts. Please provide me assembly instructions.
Re: doubt in cursor [message #200706 is a reply to message #200669] Wed, 01 November 2006 00:34 Go to previous messageGo to next message
rameshuddaraju
Messages: 69
Registered: June 2005
Location: India
Member

what is your procedure and what are those procedure variables how can we know. Provide your procedure code and tables you are using so that we can suggest some thing about that.


Re: doubt in cursor [message #200723 is a reply to message #200669] Wed, 01 November 2006 01:46 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I think you're looking for CURSOR FOR UPDATE and WHERE CURRENT OF
Previous Topic: how to know which column hold primary key
Next Topic: Query
Goto Forum:
  


Current Time: Wed Dec 07 04:52:19 CST 2016

Total time taken to generate the page: 0.08343 seconds