Extend Resultset

From: Jan van Toor <jan_at_vtwebs.nl>
Date: Tue, 09 Jul 2002 19:54:31 GMT
Message-ID: <XbHW8.596968$yP6.17381146@Flipper>

Hello,

With Interbase(Borland database) I can create Stored Procedures, which return resultsets. I
have found out that it is possible do the same thing with Oracle, using packages and REF CURSOR.

In Interbase, however, I was able to select a resultset, fetch each record of it, add some extra fields to the record (calculations etc) and after that SUSPEND the extended record.

I have seen lots of examples in Oracle opening a cursor, but no example of adding extra info to a record and then return thát record.

Could you send me such an example?

Thanks in advance
Jan van Toor Received on Tue Jul 09 2002 - 14:54:31 CDT