Re: Returning a signle result set
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
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.