Re: SELECT in "EXECUTE IMMEDIATE" returning nothing

From: Karen <abvk_at_ureach.com>
Date: Sun, 07 Jul 2002 06:51:53 GMT
Message-ID: <3D27E4D2.79B97D74@ureach.com>

> Your approch is very expensive, hard parsing of v_SQLString
> for every loop. Statement (cursor) reuse might be posible by
> creating the sql_string like select count(*) from :tab where...
> and EXECUTE IMMEDIATE v_SQLString INTO v_Result using <'table_name'>
> Try it, it might work.

No it will not. You cannot use bind variables to pass table names. Bind phase follows the parse phase, when the table names are needed.

Unless there are changes in oracle 9 which I missed out. Received on Sun Jul 07 2002 - 01:51:53 CDT