Recent changes to 37: Wrong "Version Detection" Tag In UT_PLSQL_UTIL.EXECUTE_DDLhttps://sourceforge.net/p/utplsql/bugs/37/2013-10-25T23:50:55.480000ZRecent changes to 37: Wrong "Version Detection" Tag In UT_PLSQL_UTIL.EXECUTE_DDL#37 Wrong "Version Detection" Tag In UT_PLSQL_UTIL.EXECUTE_DDL2013-10-25T23:50:55.480000Z2013-10-25T23:50:55.480000ZPaul Walkerhttps://sourceforge.net/u/p72endragon/https://sourceforge.net37431358a660dc200c40aa1573dc2b5b313d8a59<div class="markdown_content"><ul>
<li><strong>status</strong>: Open --> Verified</li>
</ul></div>Wrong "Version Detection" Tag In UT_PLSQL_UTIL.EXECUTE_DDL2013-10-24T23:37:31.602000Z2013-10-24T23:37:31.602000ZPaul Walkerhttps://sourceforge.net/u/p72endragon/https://sourceforge.net7d98216d99f4ee2e352d2c0ca577698cbb2e3528<div class="markdown_content"><p>The procedure is currently (as of v2.2.0):</p>
<div class="codehilite"><pre><span class="k">PROCEDURE</span> <span class="n">execute_ddl</span> <span class="p">(</span><span class="n">stmt</span> <span class="n">VARCHAR2</span><span class="p">)</span>
<span class="k">IS</span>
<span class="o">&</span><span class="n">start_lt_8_1</span>
<span class="n">fdbk</span> <span class="n">PLS_INTEGER</span><span class="p">;</span>
<span class="n">cur</span> <span class="n">PLS_INTEGER</span> <span class="p">:</span><span class="o">=</span> <span class="n">DBMS_SQL</span><span class="p">.</span><span class="n">open_cursor</span><span class="p">;</span>
<span class="o">&</span><span class="n">end_lt_8_1</span>
<span class="k">BEGIN</span>
<span class="o">&</span><span class="n">start_ge_8_1</span>
<span class="k">EXECUTE</span> <span class="k">IMMEDIATE</span> <span class="n">stmt</span><span class="p">;</span>
<span class="o">&</span><span class="n">start_ge_8_1</span>
<span class="o">&</span><span class="n">start_lt_8_1</span>
<span class="n">DBMS_SQL</span><span class="p">.</span><span class="n">parse</span> <span class="p">(</span><span class="n">cur</span><span class="p">,</span> <span class="n">stmt</span><span class="p">,</span> <span class="n">DBMS_SQL</span><span class="p">.</span><span class="n">native</span><span class="p">);</span>
<span class="n">fdbk</span> <span class="p">:</span><span class="o">=</span> <span class="n">DBMS_SQL</span><span class="p">.</span><span class="k">EXECUTE</span> <span class="p">(</span><span class="n">cur</span><span class="p">);</span>
<span class="n">DBMS_SQL</span><span class="p">.</span><span class="n">close_cursor</span> <span class="p">(</span><span class="n">cur</span><span class="p">);</span>
<span class="o">&</span><span class="n">end_lt_8_1</span>
<span class="n">EXCEPTION</span>
<span class="k">WHEN</span> <span class="n">OTHERS</span>
<span class="k">THEN</span>
<span class="n">RAISE</span><span class="p">;</span>
<span class="k">END</span><span class="p">;</span>
</pre></div>
<p>Note how round the <code>EXECUTE IMMEDIATE</code> line are <em>both</em> <code>&start_ge_8_1</code>. The second tag should be <code>&end_ge_8_1</code></p></div>Wrong "Version Detection" Tag In UT_PLSQL_UTIL.EXECUTE_DDL2013-10-24T23:37:31.602000Z2013-10-24T23:37:31.602000ZPaul Walkerhttps://sourceforge.net/u/p72endragon/https://sourceforge.net2ab47d25b3fbd4f243d4e68266fd711348a93987<div class="markdown_content"><p>Ticket 37 has been modified: Wrong "Version Detection" Tag In UT_PLSQL_UTIL.EXECUTE_DDL<br />
Edited By: Paul Walker (p72endragon)<br />
Status updated: u'Open' => u'Verified'</p></div>