MySQL Forums
Forum List  »  Stored Procedures

Re: Dynamic Cursor
Posted by: Peter Brawley
Date: April 08, 2019 08:55PM

Sure ...

create procedure p(v varchar(32) )
begin
  declare table_cursor cursor for
    select field1,field2 from tb_table where field3=v; 
  ...
end;



Edited 1 time(s). Last edit at 07/10/2019 09:54AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
1504
April 08, 2019 08:03PM
Re: Dynamic Cursor
391
April 08, 2019 08:55PM
1263
July 02, 2019 01:27PM


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

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.