Skip navigation links

MySQL Forums :: Cursors :: Cursor Fetch Into for Update statement Table name


Advanced Search

Re: Cursor Fetch Into for Update statement Table name
Posted by: Jay Alverson ()
Date: September 23, 2009 03:03PM

It seems to me the "fetched_cursor_row" is being analyzed as a table.
I don't think you can "load" a cursor like that.

And that the data from the cursor (any cursor) is probably formatted
in some special fashion.

So I guess you're pulling a no-no.

You could always put your data into a table then CURSOR it out and
insert the cursor data...

Seems like an extra step though.



>

Thanks, Jay

Options: Reply•Quote


Subject Views Written By Posted
Cursor Fetch Into for Update statement Table name 5815 Max Arbos 09/22/2009 10:28AM
Re: Cursor Fetch Into for Update statement Table name 2942 Max Arbos 09/23/2009 01:22PM
Re: Cursor Fetch Into for Update statement Table name 2438 Jay Alverson 09/23/2009 03:03PM
Re: Cursor Fetch Into for Update statement Table name 3334 Max Arbos 09/23/2009 03:36PM
Re: Cursor Fetch Into for Update statement Table name 2857 Jay Alverson 09/23/2009 09:05PM
Re: Cursor Fetch Into for Update statement Table name 2092 Paul Allsopp 12/10/2009 11:56AM
Re: Cursor Fetch Into for Update statement Table name 1927 Max Arbos 12/10/2009 01:50PM
Re: Cursor Fetch Into for Update statement Table name 3937 Paul Allsopp 12/10/2009 03:30PM
Re: Cursor Fetch Into for Update statement Table name 2518 Max Arbos 12/10/2009 03:54PM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.