Howto generate records in stored procedure

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 Received on Fri Sep 13 2002 - 06:24:17 CDT