Hi,
I am learning store procedure.
my table structure is
user_id int(9) primary
user_name varchar(100)
user_first_name varchar(100)
CREATE PROCEDURE Sp1(OUT p VARCHAR(100),OUT p1 VARCHAR(100),IN p2 INT)
SELECT user_name,user_first_name INTO p,p1 FROM pm_user WHERE user_id=p2;
CALL Sp1(@Name,@Fname,2);
SELECT @Name,@Fname;
Output comes like
@Name @Fname
[BLOB - 0B] [BLOB - 0B]
How to get correct output?