Board index » delphi » Oracle stored procedure returning a result set

Fabio

Delphi Developer
Thu, 29 Jul 1999 03:00:00 GMT

Oracle stored procedure returning a result set

Is it possible for an Oracle stored procedure to return a result set
usable by the TStoredProc component?

 
Marc Scheun

Delphi Developer
Fri, 30 Jul 1999 03:00:00 GMT

Re:Oracle stored procedure returning a result set


Quote
Fabio <gor...@mbox.vol.it> wrote:
>Is it possible for an Oracle stored procedure to return a result set
>usable by the TStoredProc component?

From what I know now, it's not possible, because Oracle doesn't
support it. It's possible in Interbase, though.

Marc
----------------------------------------------------------------------
Marc Scheuner, marc.scheu...@bernoise.ch    CH-3001 BERNE, Switzerland

Kári Poulse

Delphi Developer
Fri, 30 Jul 1999 03:00:00 GMT

Re:Oracle stored procedure returning a result set


Ver. 7.3 from Oracle is supposed to support result sets
from stored procedures. However, there are usually ways to
work around this, depending on what you want to do.. But
then I need to know a little about what you want to do..

For instance it is often enough just to built some PL/SQL
functions which then can be used directly in any query,
typically using the columns as parameters..

Fabio <gor...@mbox.vol.it> wrote in article
<32FDB760.4...@mbox.vol.it>...

Quote
> Is it possible for an Oracle stored procedure to return a
result set
> usable by the TStoredProc component?

Other Threads

1. Returning a result set from Oracle 8 stored procedure

2. Returning a result set from an Oracle stored procedure

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

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

5. Stored procedures returning result sets from Oracle 8.1.7

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

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

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

9. Stored procedures returning Result Sets

10. Returning Result Set from Stored Procedure