MySQL Forums
Forum List  »  Oracle

select query error
Posted by: cnu sri
Date: December 16, 2008 10:42PM

DELIMITER $$

DROP PROCEDURE IF EXISTS `yo31`.`GetFriends`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetFriends`(iUserUnqeId int)
BEGIN

declare str1 int;
set str1=( select friendid from friend where userid=iUserUnqeId);


END$$

DELIMITER ;

when i call this iam getting this error i want all my friendid into str1

Error Code : 1242
Subquery returns more than 1 row
(0 ms taken)

Options: ReplyQuote


Subject
Views
Written By
Posted
select query error
5292
December 16, 2008 10:42PM


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.