MySQL Forums
Forum List  »  Stored Procedures

After executeion of store procedure output is [BLOB - 0B]
Posted by: Amit Pawar
Date: February 05, 2011 10:20AM

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.

Options: ReplyQuote




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.