Aquileo | Recent changes to bugshttps://sourceforge.net/p/oratcl/bugs/2017-10-12T12:47:51.831000ZRecent changes to bugsAquileo | #71 Errors with long colums over 4096 characters.2017-10-12T12:47:51.831000Z2017-10-12T12:47:51.831000ZTodd Helfterhttps://sourceforge.net/u/tmh/https://sourceforge.net4909e2f68fb864b7e2f887383f94db8a9f7fa1b2<div class="markdown_content"><p>commited patch the CVS head.</p></div>Aquileo | #71 Errors with long colums over 4096 characters.2017-10-12T12:13:12.948000Z2017-10-12T12:13:12.948000ZTodd Helfterhttps://sourceforge.net/u/tmh/https://sourceforge.net1c6b7c1808b823ee6eea5c36bac15db63dbd88db<div class="markdown_content"><ul>
<li><strong>status</strong>: open --> open-accepted</li>
<li><strong>Group</strong>: --> </li>
</ul></div>Aquileo | Errors with long colums over 4096 characters.2017-10-12T12:09:53.884000Z2017-10-12T12:09:53.884000ZTodd Helfterhttps://sourceforge.net/u/tmh/https://sourceforge.net3d76a57176f93cf4c95203f813ecc266e1ec0b3a<div class="markdown_content"><p>My production version of Oracle:</p>
<p>Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production</p>
<p>I also see the same behavior with:</p>
<p>Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production</p>
<p>FYI, I am using the 32-bit Oracle libraries in my code:</p>
<p>set env(ORACLE_LIBRARY) "$env(ORACLE_HOME)/lib32/libclntsh.so"</p>
<p>I have a production problem where an Oracle LONG value is being truncated — that is, the production tcl code is not retrieving the entire field, which I determined (by using ‘sqlplus’) is just over 56,000 characters long. The field contents are straight ASCII-7 characters, as far as I know — nothing fancy like Unicode, etc.</p>
<p>The ‘oraconfig longsize’ setting in the production tcl script was set to 10 million, much longer than any expected data:</p>
<p>oraconfig $cursor longsize 10000000 </p>
<p>(I tried using a much smaller longsize of 100000. No joy.)</p>
<p>I can duplicate the problem at will. I created a test Oracle table with a single LONG field:</p>
<p>Troy Evans</p></div>Aquileo | Errors with long colums over 4096 characters.2017-10-12T12:09:53.884000Z2017-10-12T12:09:53.884000ZTodd Helfterhttps://sourceforge.net/u/tmh/https://sourceforge.netf198166af13752a5668c2f339af8b088998c77b6<div class="markdown_content"><p>Ticket 71 has been modified: Errors with long colums over 4096 characters.<br/>
Edited By: Todd Helfter (tmh)<br/>
Status updated: u'open' => u'open-accepted'</p></div>Aquileo | #70 fetch PL/SQL result in unicode mode returns nothing2016-03-29T20:15:20.917000Z2016-03-29T20:15:20.917000ZTodd Helfterhttps://sourceforge.net/u/tmh/https://sourceforge.netc47e1cf102e8f03e28a0357a143ebf59b3a02a56<div class="markdown_content"><ul>
<li><strong>status</strong>: open-accepted --> closed-wont-fix</li>
<li><strong>Group</strong>: --> </li>
</ul></div>Aquileo | #69 fetch PL/SQL result into array returns nothing2016-03-29T17:25:56.934000Z2016-03-29T17:25:56.934000ZTodd Helfterhttps://sourceforge.net/u/tmh/https://sourceforge.net318be4ca70f31ab65a4397287248acd9ee77eb4f<div class="markdown_content"><ul>
<li><strong>status</strong>: open-accepted --> closed-wont-fix</li>
<li><strong>Group</strong>: --> </li>
</ul></div>Aquileo | #69 fetch PL/SQL result into array returns nothing2016-03-29T17:25:40.421000Z2016-03-29T17:25:40.421000ZTodd Helfterhttps://sourceforge.net/u/tmh/https://sourceforge.net7781a5d0ca28a848c20ae4ef4c7eb071ddd323f8<div class="markdown_content"><p>Confirmed that 'select into variables' does not work with Oratcl. Although there is a trivial workaround. One can loop the orafetch command and assign results in the loop.</p>
<div class="codehilite"><pre><span class="x"> while </span><span class="err">{</span><span class="x">[orafetch </span><span class="p">$</span><span class="nv">smt</span><span class="x"> -datavariable row] == 0} </span><span class="err">{</span><span class="x"></span>
<span class="x"> puts </span><span class="p">$</span><span class="nv">row</span><span class="x"></span>
<span class="x"> set v [lindex </span><span class="p">$</span><span class="nv">row</span><span class="x"> 0]]</span>
<span class="x"> }</span>
</pre></div>
</div>Aquileo | #67 oratcl does not working on RHEL4 64bits2016-03-29T17:08:41.563000Z2016-03-29T17:08:41.563000ZTodd Helfterhttps://sourceforge.net/u/tmh/https://sourceforge.netf51e4b78fc571393d6faa7943e3fdf7b13902baf<div class="markdown_content"><ul>
<li><strong>status</strong>: open --> closed-wont-fix</li>
<li><strong>Group</strong>: --> </li>
</ul></div>Aquileo | #55 oradesc test suite failures2016-03-29T17:07:26.442000Z2016-03-29T17:07:26.442000ZTodd Helfterhttps://sourceforge.net/u/tmh/https://sourceforge.netc8668f8b9b82cf02aef67296d48db59c2f6383b3<div class="markdown_content"><ul>
<li><strong>status</strong>: open --> closed-works-for-me</li>
<li><strong>Group</strong>: --> </li>
</ul></div>Aquileo | #49 oratcl 4.5 test suite fails 14 tests2016-03-29T17:06:25.187000Z2016-03-29T17:06:25.187000ZTodd Helfterhttps://sourceforge.net/u/tmh/https://sourceforge.netd0a54cab441089dc7708b2c1ed392e5a451d6d9f<div class="markdown_content"><ul>
<li><strong>status</strong>: open-rejected --> closed-rejected</li>
<li><strong>Group</strong>: --> </li>
</ul></div>