Re: WIERD Behavior with BULK COLLECT in a pl/sql block - help?
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Fri, 31 Jan 2014 12:43:56 -0600
Message-ID: <CAP79kiSon00MHhyb3KPv=TByXQxoC_mXqnrev-Cx6aSSFKfFpw_at_mail.gmail.com>
To get around it, I'll have to use what I was doing - which is setting up a SQL_STR and executing the SQL_STR. That makes sense.
Date: Fri, 31 Jan 2014 12:43:56 -0600
Message-ID: <CAP79kiSon00MHhyb3KPv=TByXQxoC_mXqnrev-Cx6aSSFKfFpw_at_mail.gmail.com>
To get around it, I'll have to use what I was doing - which is setting up a SQL_STR and executing the SQL_STR. That makes sense.
Glad you guys were here to help me figure this out. Couldn't do it without you. ;)
Chris
On Fri, Jan 31, 2014 at 12:39 PM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:
> So let me guess.....even though the IF BLOCK would work on EXECUTION, it's
> FAILING during compile because I'm specifying the COLUMNS for
> &&p_table_name?
>
> Is that what's happening? If so, any suggestions to get around it?
>
> Chris
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 31 2014 - 19:43:56 CET