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

Home -> Community -> Mailing Lists -> Oracle-L -> Record or Table Function Results

Record or Table Function Results

From: Heitzig, Rich <rheitzig_at_carlson.com>
Date: Mon, 2 Oct 2000 16:19:55 -0500
Message-Id: <10637.118346@fatcity.com>


Does anyone know if there is any way to return a table or record datatype from an Oracle function, then use the returned results in a select statement? I want to return a record from a function, then join this single row (record result) to other tables in an outer query.

Any help would be appreciated.

Thanks,
rjh.



 Rich Heitzig
 Carlson Wagonlit Travel, Inc.
 763-212-5273 Desk
> <mailto: rheitzig_at_carlson.com>

Received on Mon Oct 02 2000 - 16:19:55 CDT

Original text of this message

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