Re: Library Cache

On Mon, 29 Dec 2008 07:34:17 -0800, mrdjmagnet wrote:

> Mark,
>
> How about a query done like this:
>
> v_optin_str := 'SELECT COUNT(*) FROM email_list a
> WHERE '||v_date_clause||' '||v_adid_clause||
> ' AND customer_id IS NOT NULL
> AND adid IS NOT NULL
> AND EXISTS (SELECT user_session
> FROM EMAIL_ALERTS b
> WHERE alert_type = ''OI''
> AND b.user_session =
> a.user_session)';
>
> EXECUTE IMMEDIATE v_optin_str
> INTO stats_tab(199)
> USING p_b_date, p_e_date;
>
> Is that correctly using the bind variables?

Are you freaking kidding me?

-- 
Mladen Gogala
http://mgogala.freehostia.com