Re: How to return null/empty resultset from SP??
SELECT x;
where x is a variable or a value (possibly NULL), will always return a result set consisting of exactly one row.
You can force an empty result set by using the "dummy" table DUAL: SELECT 1 FROM DUAL WHERE false;
pem, Senior Software Dev., MySQL AB
Edited 1 time(s). Last edit at 12/13/2005 07:41AM by Per-Erik Martin.
Subject
Views
Written By
Posted
5423
December 11, 2005 08:50AM
2239
December 12, 2005 04:35AM
2066
December 12, 2005 07:23AM
2074
December 12, 2005 07:28AM
1935
December 12, 2005 05:06PM
1885
December 12, 2005 07:50PM
1791
December 13, 2005 04:42AM
3325
December 13, 2005 06:29AM
Re: How to return null/empty resultset from SP??
2658
December 13, 2005 07:39AM
1902
December 13, 2005 08:08AM
1765
December 13, 2005 03:18PM
1822
December 13, 2005 07:54PM
1868
December 15, 2005 06:04AM
1740
December 15, 2005 10:07AM
2131
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.