Re: EXECUTE IMMEDIATE v_sql_stmt is not executing
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Mon, 10 Aug 2015 17:25:35 -0600
Message-ID: <55C932EF.7000509_at_gmail.com>
Which environment are you attempting to execute this in?
Date: Mon, 10 Aug 2015 17:25:35 -0600
Message-ID: <55C932EF.7000509_at_gmail.com>
Which environment are you attempting to execute this in?
If SQL Plus, what is your server output setting?
/Hans
On 10/08/2015 4:58 PM, Nik Tek wrote:
> Hi Andrew,
>
> a) there is no output printing from the v_sql_stmt
> b) DBMS_OUTPUT.PUT_LINE('v_sql_stmt: ------------------------ ' );
> didn't print
> c) If I copy/paste the output of DBMS_OUTPUT.PUT_LINE('v_sql_stmt: '
> || v_sql_stmt);, I see the query working just fine.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 11 2015 - 01:25:35 CEST