<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent posts to Discussion</title><link href="https://sourceforge.net/p/oratcl/discussion/" rel="alternate"/><link href="https://sourceforge.net/p/oratcl/discussion/feed.atom" rel="self"/><id>https://sourceforge.net/p/oratcl/discussion/</id><updated>2026-02-21T23:20:30.521000Z</updated><subtitle>Recent posts to Discussion</subtitle><entry><title>Oratcl 5.0 for Tcl 9 - is almost ready.</title><link href="https://sourceforge.net/p/oratcl/discussion/40540/thread/70aafb67ab/?limit=25#161c/1997" rel="alternate"/><published>2026-02-21T23:20:30.521000Z</published><updated>2026-02-21T23:20:30.521000Z</updated><author><name>Todd Helfter</name><uri>https://sourceforge.net/u/tmh/</uri></author><id>https://sourceforge.net62bb1fe0386d805393b7984104ee056c45e7307d</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I'll have a MacOS (apple silicon version) as well.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Oratcl 5.0 for Tcl 9 - is almost ready.</title><link href="https://sourceforge.net/p/oratcl/discussion/40540/thread/70aafb67ab/?limit=25#161c" rel="alternate"/><published>2026-02-21T23:19:36.525000Z</published><updated>2026-02-21T23:19:36.525000Z</updated><author><name>Todd Helfter</name><uri>https://sourceforge.net/u/tmh/</uri></author><id>https://sourceforge.netd87861fe80edef335a3ac91b9d61f2d978e30e80</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;It has been many years since a major update of Oratcl was made.&lt;br/&gt;
I will have version 5.0 fully modernized to run with Tcl 9 with the latest TEA available soon.&lt;/p&gt;
&lt;p&gt;If there are any features you would like included in 5.0 ,  drop a note here.&lt;/p&gt;
&lt;p&gt;-tmh&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Oratcl 4.6 running against Oracle 21c</title><link href="https://sourceforge.net/p/oratcl/discussion/40539/thread/ee76192ca4/?limit=25#c52c" rel="alternate"/><published>2022-05-08T09:22:41.628000Z</published><updated>2022-05-08T09:22:41.628000Z</updated><author><name>Miguel Bañón</name><uri>https://sourceforge.net/u/bagnon/</uri></author><id>https://sourceforge.netc334dd15fe786701f26436eeb9693373beb5360a</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;The failing DML tests are arraydml-1.1 and arraydml-1.5, the handle becomes invalid after the&lt;br/&gt;
data insertion oraexec.&lt;/p&gt;
&lt;p&gt;set tst1_1(res) &lt;span&gt;[oraexec $tst1_1(stm)]&lt;/span&gt; &amp;lt;- turns handle to an invalid state&lt;br/&gt;
oraparse $tst1_1(stm) $tst1_1(sel)&lt;br/&gt;
oraexec $tst1_1(stm)&lt;br/&gt;
while {&lt;span&gt;[orafetch $tst1_1(stm) -datavariable row]&lt;/span&gt; == 0} {&lt;br/&gt;
    # null statment&lt;br/&gt;
}&lt;/p&gt;
&lt;p&gt;The return code by the failing orafetch is "ORA-24338: statement&lt;br/&gt;
handle not executed".  Closing the current handle and opening a new&lt;br/&gt;
one works well, but it is not a solution:&lt;/p&gt;
&lt;p&gt;set tst1_1(res) &lt;span&gt;[oraexec $tst1_1(stm)]&lt;/span&gt;&lt;br/&gt;
oraclose $tst1_1(stm)                   # dirty fix&lt;br/&gt;
set tst1_1(stm) &lt;span&gt;[oraopen $tst1_1(lda)]&lt;/span&gt;  #&lt;br/&gt;
oraparse $tst1_1(stm) $tst1_1(sel)&lt;br/&gt;
oraexec $tst1_1(stm)&lt;br/&gt;
while {&lt;span&gt;[orafetch $tst1_1(stm) -datavariable row]&lt;/span&gt; == 0} { &amp;lt;-HERE&lt;br/&gt;
    # null statment&lt;br/&gt;
}&lt;/p&gt;
&lt;p&gt;Any hint?&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Oracle 19c</title><link href="https://sourceforge.net/p/oratcl/discussion/40540/thread/457df44b11/?limit=25#571f" rel="alternate"/><published>2022-02-04T17:01:43.531000Z</published><updated>2022-02-04T17:01:43.531000Z</updated><author><name>Todd Helfter</name><uri>https://sourceforge.net/u/tmh/</uri></author><id>https://sourceforge.netd65fc057332dd1accd78357e4e1969e280a6cf52</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Current version of TCL and Oratcl should work find with 19c database.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Oratcl 4.6 running against Oracle 21c</title><link href="https://sourceforge.net/p/oratcl/discussion/40539/thread/ee76192ca4/?limit=25#b6d6" rel="alternate"/><published>2022-02-04T17:00:57.723000Z</published><updated>2022-02-04T17:00:57.723000Z</updated><author><name>Todd Helfter</name><uri>https://sourceforge.net/u/tmh/</uri></author><id>https://sourceforge.net8534e2af9410b2a53d26c3e34f8aacba6fac0296</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hello Oratcl users.   Oratcl 4.6 can connect to a 21c database.   Some tests engines are failing and I will have to review what code updates are required.&lt;/p&gt;
&lt;p&gt;oralogon.test:  Total   7   Passed  7   Skipped 0   Failed  0&lt;br/&gt;
oraopen.test:   Total   5   Passed  5   Skipped 0   Failed  0&lt;br/&gt;
orainfo.test:   Total   5   Passed  5   Skipped 0   Failed  0&lt;br/&gt;
oraparse.test:  Total   2   Passed  2   Skipped 0   Failed  0&lt;br/&gt;
orabind.test:   Total   11  Passed  11  Skipped 0   Failed  0&lt;br/&gt;
oraexec.test:   Total   11  Passed  11  Skipped 0   Failed  0&lt;br/&gt;
orafetch.test:  Total   2   Passed  2   Skipped 0   Failed  0&lt;br/&gt;
oracols.test:   Total   1   Passed  1   Skipped 0   Failed  0&lt;br/&gt;
&lt;strong&gt;oradesc.test: Total   13  Passed  7   Skipped 0   Failed  6&lt;/strong&gt;&lt;br/&gt;
oracommit.test: Total   4   Passed  4   Skipped 0   Failed  0&lt;br/&gt;
&lt;strong&gt;oralob.test:  Total   31  Passed  30  Skipped 0   Failed  1&lt;/strong&gt;&lt;br/&gt;
oralong.test:   Total   6   Passed  6   Skipped 0   Failed  0&lt;br/&gt;
slaveinterps.test:  Total   10  Passed  10  Skipped 0   Failed  0&lt;br/&gt;
orasql.test:    Total   7   Passed  7   Skipped 0   Failed  0&lt;br/&gt;
orabindexec.test:   Total   6   Passed  6   Skipped 0   Failed  0&lt;br/&gt;
oraplexec.test: Total   10  Passed  10  Skipped 0   Failed  0&lt;br/&gt;
codes.test: Total   7   Passed  7   Skipped 0   Failed  0&lt;br/&gt;
async.test: Total   21  Passed  21  Skipped 0   Failed  0&lt;br/&gt;
usertype.test:  Total   0   Passed  0   Skipped 0   Failed  0&lt;br/&gt;
merge.test: Total   1   Passed  1   Skipped 0   Failed  0&lt;br/&gt;
unicode.test:   Total   5   Passed  5   Skipped 0   Failed  0&lt;br/&gt;
&lt;strong&gt;arraydml.test:    Total   5   Passed  3   Skipped 0   Failed  2&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;I will be investigating what changes are required.&lt;/p&gt;
&lt;p&gt;On first glance the numeric code for CLOB appears to have changed from 86 to 114.&lt;/p&gt;
&lt;p&gt;-Todd Helfter&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Oracle 19c</title><link href="https://sourceforge.net/p/oratcl/discussion/40540/thread/457df44b11/?limit=25#b475" rel="alternate"/><published>2021-10-19T17:40:47.277000Z</published><updated>2021-10-19T17:40:47.277000Z</updated><author><name>pk2703</name><uri>https://sourceforge.net/u/iampushpesh/</uri></author><id>https://sourceforge.netd0d11ba83456a63bf09850171aef1cf646db673c</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;We are going to upgrade oracle database from 11.2.0.4.0 to 19.x&lt;br/&gt;
Currently we are using 8.5.13 version for TCL&lt;br/&gt;
Will current version of TCL work with 19.x Oracle database? or we will need to update it?&lt;/p&gt;
&lt;p&gt;OS : Solaris 10&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Oratcl 4.6 on Oracle 18c</title><link href="https://sourceforge.net/p/oratcl/discussion/40540/thread/15201430d9/?limit=25#85be" rel="alternate"/><published>2019-03-26T18:34:22.263000Z</published><updated>2019-03-26T18:34:22.263000Z</updated><author><name>Todd Helfter</name><uri>https://sourceforge.net/u/tmh/</uri></author><id>https://sourceforge.netc4798e5879ee82ceada3f1b294a40669ac451c14</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;first clue:&lt;/p&gt;
&lt;p&gt;oci.h :  #define OCI_FNCODE_LOBLENGTH2  114&lt;br/&gt;
Instead of the oracols.test using a hard coded value of 86, I should see if I can determine the lob  length programatically.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Oratcl 4.6 on Oracle 18c</title><link href="https://sourceforge.net/p/oratcl/discussion/40540/thread/15201430d9/?limit=25#421b" rel="alternate"/><published>2019-03-26T18:29:42.217000Z</published><updated>2019-03-26T18:29:42.217000Z</updated><author><name>Todd Helfter</name><uri>https://sourceforge.net/u/tmh/</uri></author><id>https://sourceforge.net5af272ff741d52d0e562bafe33836fe469d64167</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I have just attempted to run the test suite for Oratcl against 18c for the first time.&lt;/p&gt;
&lt;p&gt;tcl : 8.6.7&lt;br/&gt;
oratcl : 4.6&lt;/p&gt;
&lt;p&gt;oracle client : 18.3.0.0.0 (x86-64 linux)&lt;br/&gt;
oracle database : 18.0.0.0.0 (x86-64 linux)&lt;/p&gt;
&lt;p&gt;I'm seeing errors in these tests:&lt;br/&gt;
oracols.test&lt;br/&gt;
oradesc.test&lt;br/&gt;
oralob.test&lt;br/&gt;
arraydml.test&lt;/p&gt;
&lt;p&gt;This appears to be related to the size of a lob_locator being increased from 86 to 114.&lt;/p&gt;
&lt;p&gt;I will begin remediation efforts to see what has changed and provide a patch.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>oralogon returns ORA-24315</title><link href="https://sourceforge.net/p/oratcl/discussion/40540/thread/68f08fdd/?limit=25#a982" rel="alternate"/><published>2019-03-12T14:04:52.279000Z</published><updated>2019-03-12T14:04:52.279000Z</updated><author><name>Todd Helfter</name><uri>https://sourceforge.net/u/tmh/</uri></author><id>https://sourceforge.net82ec947de0f98e5588479acf0da07f3e8e508545</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I have not seen this error before, but have not used 10g in a very long time. &lt;br/&gt;
If this is still a concern, please attach the version of your OS (32b or 64b) and the version of Oracle 10 and I will attempt to recreate a test case.&lt;/p&gt;
&lt;p&gt;-Todd&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>oralogon returns ORA-24315</title><link href="https://sourceforge.net/p/oratcl/discussion/40540/thread/68f08fdd/?limit=100#4b3e" rel="alternate"/><published>2018-07-03T13:30:58.176000Z</published><updated>2018-07-03T13:30:58.176000Z</updated><author><name>Jens Georg Frøjk</name><uri>https://sourceforge.net/u/j-g-froejk/</uri></author><id>https://sourceforge.net8174ff12d1d010be140e22453f54da8a11521c9a</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Anybody got the ORA-24315 error when doing oralogon ?&lt;br/&gt;
And know a resolution?&lt;/p&gt;
&lt;p&gt;I do:&lt;br/&gt;
  set lda &lt;span&gt;[oralogon bmssa/bmssa_pwd@AX30TEST]&lt;/span&gt;&lt;br/&gt;
Then Oratcl returns&lt;br/&gt;
  ORA-24315: illegal attribute type &lt;/p&gt;
&lt;p&gt;I have done a lot of SQLNET trace, strip down the TNS, ... ect., but no luck.&lt;/p&gt;
&lt;p&gt;The enviroment is Oracle 10g on windows and Oratcl46.dll.&lt;br/&gt;
The Oratcl is part of the HammerDB test tool. I do not know if Oratcl46.dll was compiled by them.&lt;br/&gt;
So as long I have this error, I can not use the HammerDB test tool, and benchmark my new Oracle Database Server.&lt;/p&gt;
&lt;p&gt;/Georg&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>