If I use the Execute Command window to run a SELECT statement, the results are
displayed in the lower half of the window. If I use it to execute a stored
procedure that returns a result set, all I see is a dialog saying 'Command
successfully executed' - the results are not displayed. Since we have an audit
requirement that all database access should be done through SPs, it's a major
limitation not to be able to test them...
You are right. The results are displayed only for SELECT statements.
Stored procedures may return multiple result sets and the Execute
Command window isn't designed to display more then one result set.
(This window was originally designed to execute SELECT statements only
and the possibility to execute other kinds of SQL/DDL commands was
We are working on new generation of the Database Explorer module which
should be able to display more result sets. This new module is based
on different architecture and we write the module from the scratch.
That's why I changed the issue type from DEFECT to ENHANCEMENT - we
don't plan to add any new features to the current module. We don't
work on it any more and we fix the most critical bugs only.
What can I try to do is to display the results for stored procedures
which return a simple result set only. If you want to display the
results for stored procedures which return multiple result sets in the
current module you can try to modify the current implementation of the
Execute Command window and contribute it. It should not be difficult
(good starting point is
Target milestone -> 3.3.1.
Will be investigated for new module based on MDR.
Resolved for 3.3.x or earlier, no new info since then -> closing.
A mistakenly closed RESOLVED LATER/REMIND issue. Reopening.
I can't tell - is this working now for a single result set?
Not sure and I don't have time to check it now. From a quick look at the code I
think it should work. Could you please try it? E.g. with a simple SP on Derby?
Yes, I'll give it a try.
*** Issue 127596 has been marked as a duplicate of this issue. ***
Verified with build 080714.