Re: **PLEASE HELP** Oracle Stored Procedures question

From: Marc Scheuner <marc.scheuner_at_NO.SPAM.PLEASE.ch>
Date: 1997/05/20
Message-ID: <33814860.4144930@news.bernoise.ch>#1/1

Nnoor_at_cris.com (NNOOR) wrote:
>I have many complex queries in my client app which I would like to
>have stored on the server side to cut down on many time/resource
>intensive variables.
>
>I can't seem to figure out how to return a result set from the
>Oracle stored procedures.

No wonder, it's currently simply not supported by Oracle. They promise it for Oracle 8........

As Jasper already pointed out, for a complex query to return a result set, I'd use either a view or a parametrized TQuery (don't forget to prepare it before using it!).

HTH
Marc

---

Marc Scheuner, marc.scheuner_at_bernoise.ch CH-3001 BERNE, Switzerland Received on Tue May 20 1997 - 00:00:00 CDT