Re: Syntax Question
From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Sat, 9 Feb 2008 11:21:09 -0800 (PST)
Message-ID: <9e618f1c-1faf-4e17-9645-43b4d385bbdd@q21g2000hsa.googlegroups.com>
Date: Sat, 9 Feb 2008 11:21:09 -0800 (PST)
Message-ID: <9e618f1c-1faf-4e17-9645-43b4d385bbdd@q21g2000hsa.googlegroups.com>
On Feb 9, 9:12 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Oracle 10.2.0.3.0
> Windows Server 2003
>
> Sorry for this question but our database is currently unavailable so I can't
> try it myself.
>
> Is the following syntax valid for loading a nested table in bulk from a
> table function?
>
> SELECT *
> BULK COLLECT INTO nt_claims_rec
> FROM TABLE(get_claims() );
>
> Thanks.
Yes, but why? If nt_claims_rec is of the same nested table type as get_claims() returns (and most probably this is so,) simple assignment will do:
nt_claims_rec := get_claims();
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Sat Feb 09 2008 - 13:21:09 CST