Variable table name for cursor

Dreea

Hello all

What is the appropriate syntax for declaring a cursor for a table name that is passed as a parameter to a procedure? I tried several combination and it doesn't seem to work.

CREATE PROCEDURE PROC(tableName varchar(50))
BEGIN
DECLARE cursorName CURSOR FOR SELECT column1,column2 FROM tableName;
END

The select statement can not be a variable, also it's not working with PREPARE statement.

Can anyone help me on this matter?
Thanks in advance :)

blyxx86

Does this help you?

Expand|Select|Wrap|Line Numbers

 
create procedure cursorproc(IN p_in INT, OUT p_out VARCHAR(30))

begin
 
   declare l_emp_name VARCHAR(30);

   declare cur_1 cursor for select emp_name from emps where emp_id = p_in;
 
   open cur_1;

   fetch cur_1 into l_emp_name;

   close cur_1;
 
   set p_out = l_emp_name;
 
end;

Variable table name for cursor

re: Variable table name for cursor

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about