Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newshub.sdsu.edu!news.glorb.com!news.hub.org!sn-xt-sjc-02!sn-xt-sjc-08!sn-post-sjc-01!supernews.com!corp.supernews.com!not-for-mail
From: Sybrand Bakker <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: SELECT FROM TABLE(CAST... failure
Date: Fri, 07 Jul 2006 21:54:02 +0200
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <jseta2d3eesb6boggj49gdp29rh8rf3tkv@4ax.com>
Reply-To: sybrandb@hccnet.verwijderdit.nl
References: <pan.2006.07.06.19.22.40.641000@google.com> <1152214937.893109@bubbleator.drizzle.com> <pan.2006.07.06.19.56.38.782000@google.com> <1152218487.162464@bubbleator.drizzle.com> <pan.2006.07.06.21.12.10.109000@google.com>
X-Newsreader: Forte Agent 3.3/32.846
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@supernews.com
Lines: 20
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270622

On Thu, 06 Jul 2006 17:12:10 -0400, meathammer <googler@google.com>
wrote:

>On Thu, 06 Jul 2006 13:41:25 -0700, DA Morgan wrote:
>> with apologies for shouting:
>> 
>> BECAUSE IT DOESN'T RETURN ANYTHING.
>
>huh ? I'm not calling a function...I want to reference pkg variable
>"testpkg.eml_dmo_nt"
>
>SQL> SELECT * FROM TABLE(CAST(testpkg.eml_dmo_nt AS email_demo_nt_t)) ;
>
>
You can't reference package variables (or constants) even if they are
in the package specification. You'll need a very simply function to
RETURN them.

--
Sybrand Bakker, Senior Oracle DBA