Board index » delphi » Stored procedures returning Result Sets

Dave Bhatia

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Stored procedures returning Result Sets

I realize that Interbase has a feature that can return a result set of one
or more rows via stored procedure. Correct me if I'm wrong; one could take
this result set and set it to a TDataset descendent for read-only purpose.

Can anyone tell me out of experience, which back-end database they've used
may be incompatible with this feature?

For example: Is there any back-end database such as Oracle, SQL server which
does support the robustness of result sets from a Stored Procedure.

Tia,

Dave Bhatia

 
Jason FitzHarri

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Stored procedures returning Result Sets


Dave,
   MSSQL returns results set for displaying on grids and the like.

Regards,
Jason.

No spam, unless requested. Thanks.

John Pierc

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Stored procedures returning Result Sets


Oracle can return a result set from an SP in a cursor, the equivalent of
a query against a table.

John Pierce

Ping Ka

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Stored procedures returning Result Sets


Oracle SP does not return result set.  You have to use a ref cursor.

Ping

Quote
Jason FitzHarris <jasf...@indigo.ie> wrote in message

news:8gm9je$bfb7@bornews.borland.com...
Quote
> Dave,
>    MSSQL returns results set for displaying on grids and the like.

> Regards,
> Jason.

> No spam, unless requested. Thanks.

Robert Cern

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Stored procedures returning Result Sets


This is standard feature. Most (if not all) of servers support this or
better - I didn't hear of any that does not support this. Naturally, each
server has its own syntax and some support additional features (like
multiple result sets), but client can handle them all in the same way.
What do you mean with "robustness of result sets from a Stored Procedure"?
That all other result sets are weak?
--
----------------------
Regards
Robert Cerny
Remove both qwe when replying
email: robert.qwe.ce...@neosys.xrs.qwe.si

No questions via email, unless explicitly invited.

Quote
Dave Bhatia wrote in message <8gm9bl$b...@bornews.borland.com>...
>I realize that Interbase has a feature that can return a result set of one
>or more rows via stored procedure. Correct me if I'm wrong; one could take
>this result set and set it to a TDataset descendent for read-only purpose.

>Can anyone tell me out of experience, which back-end database they've used
>may be incompatible with this feature?

>For example: Is there any back-end database such as Oracle, SQL server
which
>does support the robustness of result sets from a Stored Procedure.

>Tia,

>Dave Bhatia

John Pierc

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Stored procedures returning Result Sets


Quote
Ping Kam wrote:
> Oracle SP does not return result set.  You have to use a ref cursor.

> Ping

Actually, the SP returns the result set *in* a ref cursor.

John Pierce

Ping Ka

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Stored procedures returning Result Sets


The way Interbase SP and Oracle SP returning the result set is very
different.  With Oracle, a SP is not capable of returning a result set.  One
must open a ref cursor and pass it through an out parameter.  But interbase
SP is capable of returning a result set, you do not have to use a parameter.

Ping

Quote
John Pierce <jpie...@healthplanning.com> wrote in message

news:392EE28E.4147C8B1@healthplanning.com...
Quote

> Ping Kam wrote:

> > Oracle SP does not return result set.  You have to use a ref cursor.

> > Ping

> Actually, the SP returns the result set *in* a ref cursor.

> John Pierce

Other Threads

1. PROBLEM: Stored Procedure returning result set in Delphi6/dbExpress/Oracle 8.1.7

2. Stored procedures returning result sets from Oracle 8.1.7

3. Oracle stored procedure returning a result set

4. Returning a result set via cursor in SQL Server stored procedure

5. ENoResultSet exception on stored procedure that actually returns a result set

6. ENoResultSet on stored procedure that actually returns a result set

7. Returning a result set from Oracle 8 stored procedure

8. Returning a result set from an Oracle stored procedure

9. Returning Result Set from Stored Procedure

10. Oracle 7.3 Returning a result set from a stored procedure