Re: Howto generate records in stored procedure

Jan van Toor wrote:

> Hi guys,
>
> I have got to write a stored procedure, which reads the contents of a table.
> For every record read, three identical records must be generated in a
> resultset (or temp table?). The resultset is connected to a REF CURSOR in a
> package.
>
> I work with Oracle7, so a lot of goodies like temp tables and Object-types
> can't be used.
> Do you know a solution? A code-snippet would be highly appreciated!
>
> Thanks in advance,
> Jan van Toor

Temp tables are irrelevant to what you are trying to do. Just open a cursor, fetch the record, and then follow the fetch with your three inserts. Easily done in version 7. No need for anything fancy.

But you are working with REF CURSORS in Oracle 7? Really?

Daniel Morgan Received on Fri Sep 13 2002 - 10:39:18 CDT