title: ORA-01756: quoted string not properly terminated
body: <pre><code>please let me know the issue with following script (sql,oracle 10g)
  
    1  DECLARE @colname AS NVARCHAR(50)
    2  DECLARE @tablename AS NVARCHAR(500)
    3  DEClARE @query AS NVARCHAR(500)
    4  SET @colname = 'select wk_units1 from cnt_sls_dm.fct_sales_summary'
    5  SET @tablename = 'SELECT tablename from dmi_user.fct_sales_meta'
    6  set @query='select '+@colname+' FROM '+@tablename+'
    7* EXECUTE sp_executesql @query
  SQL&gt; /
  ERROR:
  ORA-01756: quoted string not properly terminated
  </code></pre>