Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SELECT FROM TABLE(CAST... failure
On Thu, 06 Jul 2006 17:12:10 -0400, meathammer <googler_at_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 DBAReceived on Fri Jul 07 2006 - 14:54:02 CDT