Re: [GENERAL] Building a record in a function

2007-02-27 Thread Richard Huxton
Robert Fitzpatrick wrote: Haven't done a whole lot of plsql returning records, only those based on a query. I was wondering, can I build a record from the results of the query using other values for some fields in the record? I know 'return next' requires a record and want to build my own record

[GENERAL] Building a record in a function

2007-02-27 Thread Robert Fitzpatrick
Haven't done a whole lot of plsql returning records, only those based on a query. I was wondering, can I build a record from the results of the query using other values for some fields in the record? I know 'return next' requires a record and want to build my own record to include some argument val