<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to patches</title><link href="https://sourceforge.net/p/oratcl/patches/" rel="alternate"/><link href="https://sourceforge.net/p/oratcl/patches/feed.atom" rel="self"/><id>https://sourceforge.net/p/oratcl/patches/</id><updated>2007-10-02T12:27:45Z</updated><subtitle>Recent changes to patches</subtitle><entry><title>regression: orafetch -command doesn't return rc code</title><link href="https://sourceforge.net/p/oratcl/patches/7/" rel="alternate"/><published>2007-10-02T12:27:45Z</published><updated>2007-10-02T12:27:45Z</updated><author><name>Christoph Bauer</name><uri>https://sourceforge.net/u/fridolin/</uri></author><id>https://sourceforge.net8e744c190ae7d1b7f651d8968bfb2434d0d46b38</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;With oratcl4.3 I wrote this code.&lt;/p&gt;
&lt;p&gt;while { [orafetch $c -datavariable row -command {&lt;br /&gt;
uplevel $cmd&lt;br /&gt;
}]] == 0 } {}&lt;/p&gt;
&lt;p&gt;It works as expected. But not with Oratcl 4.4!&lt;br /&gt;
In Oratcl_Fetch the call to Tcl_EvalObjEx() overwrites the result. My trivial patch restores the behaviour of Oratcl 4.3:&lt;/p&gt;
&lt;p&gt;*** oratcl.c.old        Tue Apr 25 16:29:11 2006&lt;br /&gt;
--- oratcl.c    Tue Oct  2 14:16:22 2007&lt;br /&gt;
***************&lt;br /&gt;
*** 5984,5989 ****&lt;br /&gt;
--- 5984,5991 ----&lt;/p&gt;
&lt;p&gt;if (evalObjPtr) {&lt;br /&gt;
tcl_return = Tcl_EvalObjEx(interp, evalObjPtr, 0);&lt;br /&gt;
+                 if( tcl_return == TCL_OK )&lt;br /&gt;
+                   Tcl_SetObjResult(interp, Tcl_NewIntObj(0));&lt;br /&gt;
}&lt;/p&gt;
&lt;p&gt;common_exit:&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Patch to make Oratcl load in a mixed 8i, 9i and 10g env</title><link href="https://sourceforge.net/p/oratcl/patches/6/" rel="alternate"/><published>2006-05-17T10:47:27Z</published><updated>2006-05-17T10:47:27Z</updated><author><name>Jackson McCann</name><uri>https://sourceforge.net/u/rjmccann/</uri></author><id>https://sourceforge.net4a27477e5d7edf447fb23fcbc51a0d4c54dc9d51</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;We are running a mixture of Oracle versions, 32 bit &lt;br /&gt;
8i and 64 bit 10g.  As we want to continue with a 32 &lt;br /&gt;
bit version of Tcl there is a problem finding the &lt;br /&gt;
correct version of the libclntsh.so library.  For 8i &lt;br /&gt;
it's in the lib directory and for 10g it's in the &lt;br /&gt;
lib32 directory.&lt;/p&gt;
&lt;p&gt;The attcahed file patches the oratcl.c file to try &lt;br /&gt;
the lib32 directory if it fails to load the &lt;br /&gt;
libclntsh.so from the lib directory.&lt;/p&gt;
&lt;p&gt;I've tested this on Solaris 8 with Oracle 8.1.4 and &lt;br /&gt;
10.1.0.&lt;/p&gt;
&lt;p&gt;I don't known if this is something you want in the &lt;br /&gt;
core but as I'd written it I thought I would share :-)&lt;/p&gt;
&lt;p&gt;Jackson&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Logon errors not handled correctly</title><link href="https://sourceforge.net/p/oratcl/patches/5/" rel="alternate"/><published>2005-03-22T13:27:12Z</published><updated>2005-03-22T13:27:12Z</updated><author><name>Aktar</name><uri>https://sourceforge.net/u/aktarahmed/</uri></author><id>https://sourceforge.net415edbe7de72682eddf8b75cc97660e9c22c79f7</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;In Oratcl 4.3, some improvements have been made with &lt;br /&gt;
the way errors are displayed on logon failure. However, &lt;br /&gt;
this does not take into account the error code ORA-&lt;br /&gt;
28002 which is a warning that the password is about to &lt;br /&gt;
expire but does not prevent logon.&lt;/p&gt;
&lt;p&gt;The attached patch (for oratcl.c-1.102..2.21) resolves &lt;br /&gt;
this issue and allows the logon to succeed and places &lt;br /&gt;
the warning in the oramsg buffer.&lt;/p&gt;
&lt;p&gt;Furthermore, I have provided a patch for the 4-1 branch &lt;br /&gt;
which achieves the same result. Additionally, the actual &lt;br /&gt;
error message is returned in the Tcl buffer instead of the &lt;br /&gt;
fixed "invalid password" string.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Array DML</title><link href="https://sourceforge.net/p/oratcl/patches/4/" rel="alternate"/><published>2003-06-10T02:08:05Z</published><updated>2003-06-10T02:08:05Z</updated><author><name>Jeremy Collins</name><uri>https://sourceforge.net/u/jcollins/</uri></author><id>https://sourceforge.net6986ad26349c79fefc30933df6c60ecad7ac725d</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;This patch adds array dml to oratcl.  This allows for&lt;br /&gt;
seriously improved performance when insert/updating a&lt;br /&gt;
lot of data.  Instead of executing an insert/update for&lt;br /&gt;
each row oratcl will now allow you to past a list of&lt;br /&gt;
values to be inserted/updated and it will send all of&lt;br /&gt;
this data to the database to be processed.  See orabind&lt;br /&gt;
for more on this.&lt;/p&gt;
&lt;p&gt;The statement will also execute in batch error mode. &lt;br /&gt;
This allows Oracle to process *all* the data and then&lt;br /&gt;
just let you know which rows failed so you can correct&lt;br /&gt;
them and retry.  See oramsg for more on this.&lt;/p&gt;
&lt;p&gt;See the docs.  The orabind, and oramsg commands were&lt;br /&gt;
modified to make this new feature work.&lt;/p&gt;
&lt;p&gt;Examples:&lt;br /&gt;
-----------------------------------------------&lt;br /&gt;
set sql &amp;amp;quot;insert into mytable (col1) values (:val1)&amp;amp;quot;&lt;br /&gt;
set values [list 1 2 3 4 5]&lt;br /&gt;
oraparse $stmt $sql&lt;br /&gt;
orabind $stmt -arraydml :val1 $values&lt;br /&gt;
oraexec $stmt&lt;br /&gt;
-----------------------------------------------&lt;/p&gt;
&lt;p&gt;The example above will insert 5 rows, one row for each&lt;br /&gt;
of the values in the list.  And it will do it *very*&lt;br /&gt;
fast compared to calling orabind/oraexec 5 times.&lt;/p&gt;
&lt;p&gt;This patch was made against the oratcl-4-1-branch.&lt;/p&gt;
&lt;p&gt;Performance&lt;br /&gt;
----------------------------------------------&lt;br /&gt;
INSERTING 5000 rows (array dml):  3.33 seconds&lt;br /&gt;
INSERTING 5000 rows (orabind/oraexec):  28.85 seconds&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>oradesc broken in 3.3 for syn</title><link href="https://sourceforge.net/p/oratcl/patches/3/" rel="alternate"/><published>2002-12-05T21:27:47Z</published><updated>2002-12-05T21:27:47Z</updated><author><name>Kevin Rodgers</name><uri>https://sourceforge.net/u/userid-662991/</uri></author><id>https://sourceforge.netd5cc3515d4a8f6619802b32bece6fa031f6afc8e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Here is a slightly better patch than the one Bastien&lt;br /&gt;
Chevreux &amp;amp;lt;bach&amp;amp;gt; posted with bug report 544152.  This&lt;br /&gt;
sets ec to the result of Oratcl_Checkerr() instead,&lt;br /&gt;
just as is done at the top of the loop:&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Support for &amp;amp;quot;named type&amp;amp;quot; columns</title><link href="https://sourceforge.net/p/oratcl/patches/2/" rel="alternate"/><published>2002-09-11T22:11:02Z</published><updated>2002-09-11T22:11:02Z</updated><author><name>Olly Stephens</name><uri>https://sourceforge.net/u/ollystephens/</uri></author><id>https://sourceforge.net7b5c338b45b75d29d019626112f8ebf2b7231b3c</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;This is a small patch for oratcl.c which adds support &lt;br /&gt;
for oracle named type columns in the &amp;amp;quot;oradesc&amp;amp;quot; &lt;br /&gt;
command.  For example, a column of type &amp;amp;quot;XMLType&amp;amp;quot; &lt;br /&gt;
was previously reported as &amp;amp;quot;UNKNOWN&amp;amp;quot; will be &lt;br /&gt;
correctly reported.  It has only been tested against 9i &lt;br /&gt;
as that's all I have available to me.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Update oddis (from 2.7) for 3.1+</title><link href="https://sourceforge.net/p/oratcl/patches/1/" rel="alternate"/><published>2001-03-30T01:03:15Z</published><updated>2001-03-30T01:03:15Z</updated><author><name>Benjamin Lewis</name><uri>https://sourceforge.net/u/bhlewis/</uri></author><id>https://sourceforge.net52f4280ed7a402191940ca691f9ac370ecce223e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;This patch updates Oddis2.11 (distributed with &lt;br /&gt;
Oratcl2.7) to work with Oratcl3.1+&lt;/p&gt;
&lt;p&gt;The patch is lightly tested, but does work for&lt;br /&gt;
simple queries.&lt;/p&gt;
&lt;p&gt;The file oddis2.11 is changed to use wishx rather&lt;br /&gt;
than orawishx and use the &amp;amp;quot;package require&amp;amp;quot; command&lt;br /&gt;
to load Oratcl.  You will still need to edit the&lt;br /&gt;
module_name definition per the Oddis README.&lt;/p&gt;
&lt;p&gt;The file orafunc.tcl is changed to use the new&lt;br /&gt;
oracols command options rather than the deprecated&lt;br /&gt;
oramsg array to obtain table/query column descriptions.&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>