Smalltalk › Cincom › VisualWorks

Multiple Result Sets from SQL Query

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Runar Jordahl

Multiple Result Sets from SQL Query

For performance reasons we want to execute multiple SQL selects in one
command. We want VisualWorks 7.4 to return multiple answer sets.
Consider this code snippet:

session prepare: 'select * from a; select * from b'.
session execute.

I have been told this works on SQL Server 2005 using ODBC driver. With
Oracle 10g it does not seem to work. Does anyone know if this function
is supported for Oracle? Or do I need to run a PL/SQL-function to get
this working?

Bruce Badger

Re: Multiple Result Sets from SQL Query

On 02/03/07, Runar Jordahl <[hidden email]> wrote:

> For performance reasons we want to execute multiple SQL selects in one
> command. We want VisualWorks 7.4 to return multiple answer sets.
> Consider this code snippet:
>
> session prepare: 'select * from a; select * from b'.
> session execute.
>
> I have been told this works on SQL Server 2005 using ODBC driver. With
> Oracle 10g it does not seem to work. Does anyone know if this function
> is supported for Oracle? Or do I need to run a PL/SQL-function to get
> this working?

For completeness and FWIW I'll mention that this is supported by the
PostgreSQL driver. Have a look at PostgreSQLTest>>test11.

All the best,
Bruce
--
Make the most of your skills - with OpenSkills
http://www.openskills.org/

Thomas Gagné-2

Re: Multiple Result Sets from SQL Query

In reply to this post by Runar Jordahl

I hope you get some Oracle users to respond. EXDI handles it pretty
well for Sybase' CTLib.

--
Visit <http://tggagne.blogspot.com/>,<http://gagne.homedns.org/> or
<http://gagne.homedns.org/~tgagne/> for more great reading.