Re: How to return null/empty resultset from SP??
Posted by:
Ming Yeung
Date: December 12, 2005 07:50PM
O...*_*...still no luck.
It returns [0] even I tried to set...
...
SET ret_id = NULL;
SELECT ret_id;
END
Actually, this can be solved(fool) by applying the same SELECT statement before END or modify the java code...
rs.next();
if(rs.getInt("ret_id")==0)
not found
else
found
But, but I do not think these are good.
Subject
Views
Written By
Posted
5191
December 11, 2005 08:50AM
2121
December 12, 2005 04:35AM
1973
December 12, 2005 07:23AM
1979
December 12, 2005 07:28AM
1843
December 12, 2005 05:06PM
Re: How to return null/empty resultset from SP??
1789
December 12, 2005 07:50PM
1703
December 13, 2005 04:42AM
3193
December 13, 2005 06:29AM
2451
December 13, 2005 07:39AM
1791
December 13, 2005 08:08AM
1668
December 13, 2005 03:18PM
1734
December 13, 2005 07:54PM
1771
December 15, 2005 06:04AM
1624
December 15, 2005 10:07AM
2043
January 15, 2006 11:50AM
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.