Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: function return recordset definition in a package
On Apr 11, 4:18 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> >>> RETURN t_TabScore
> >>> PARALLEL_ENABLE (PARTITION pMCD BY HASH (individual_key))
> >>> PIPELINED
> >>> IS
> >>> --<<right here>> ....how do I see the field name and format for
> >>> out_rec??
> >>> out_rec t_RecScore;
> >>> in_rec pMCD%ROWTYPE
>
> I'd say look at the code for either a type definition for t_TabScore or in
> your database as an object table.
thanks for the suggestions. I finally found a piece of stand-alone code (not part of the package) that created the structure as a type and give me the userID to use. Fropm that, it was a simple describe. Received on Tue Apr 24 2007 - 11:15:27 CDT