Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXECUTE IMMEDIATE + BULK COLLECT without knowing in advance the number of columns fetched ?
On Sep 14, 1:45 pm, codadilupo <codadil..._at_operamail.com> wrote:
> DA Morgan wrote:
> > Your question was about EXECUTE IMMEDIATE and BULK COLLECT.
>
> Perhaps I did't explained me too well. My question was: how can I code a
> SELECT statement using EXECUTE IMMEDIATE ... BULK COLLECT INTO if I
> don't know in advance the number of columns to fetch? (I can only assume
> they are all NUMBERs). I noticed the code you posted: perhaps it is me,
> but I'm not able to see the relationship with my issue.
>
> Thank you. Kind regards,
>
> --
> CdL
Have a look at this article on method 4 dynamic SQL in PL/SQL: http://www.oracle-developer.net/display.php?id=422 Received on Sun Sep 16 2007 - 01:21:58 CDT
![]() |
![]() |