After executeion of store procedure output is [BLOB - 0B]

[Amit Pawar]

Hello,

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?



Edited 1 time(s). Last edit at 02/05/2011 10:22AM by Amit Pawar.