MySQL Forums
Forum List  »  Stored Procedures

Re: Returning a signle result set
Posted by: Stephen Dougall
Date: December 15, 2005 05:51AM

hi,

Okay, here's my real procedure with the names changed.

CREATE PROCEDURE proc_X ( YVARCHAR(25), YVARCHAR(25) )
BEGIN

DECLARE varA BIGINT;

SELECT colX INTO varA FROM tableX
WHERE Y= colB;

SELECT varA;

IF (SELECT varA IS NULL) THEN
SELECT FALSE AS result;
ELSE
SELECT TRUE AS result;

END IF;

It runs fine. The problem for me is when I read in the result of the statement in java I appear to get a result set for the first select statement rather that the result set for the last select statement (which is what I want). What I want to know is if I can return only the result set for the last select statement?

Thanks for your help
Steve

Options: ReplyQuote


Subject
Views
Written By
Posted
2196
December 15, 2005 05:01AM
1361
December 15, 2005 05:41AM
Re: Returning a signle result set
1447
December 15, 2005 05:51AM
1445
December 15, 2005 06:42AM


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.