Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: function return recordset definition in a package

Re: function return recordset definition in a package

From: NoSpamDrew <nospamdrew_at_gmail.com>
Date: 24 Apr 2007 09:15:27 -0700
Message-ID: <1177431327.367815.255130@t39g2000prd.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US