The failing DML tests are arraydml-1.1 and arraydml-1.5, the handle becomes invalid after the data insertion oraexec. set tst1_1(res) [oraexec $tst1_1(stm)] <- turns handle to an invalid state oraparse $tst1_1(stm) $tst1_1(sel) oraexec $tst1_1(stm) while {[orafetch $tst1_1(stm) -datavariable row] == 0} { # null statment } The return code by the failing orafetch is "ORA-24338: statement handle not executed". Closing the current handle and opening a new one works well, but it is not a solution: set...
Current version of TCL and Oratcl should work find with 19c database.
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. oralogon.test: Total 7 Passed 7 Skipped 0 Failed 0 oraopen.test: Total 5 Passed 5 Skipped 0 Failed 0 orainfo.test: Total 5 Passed 5 Skipped 0 Failed 0 oraparse.test: Total 2 Passed 2 Skipped 0 Failed 0 orabind.test: Total 11 Passed 11 Skipped 0 Failed 0 oraexec.test: Total 11 Passed 11 Skipped 0 Failed 0 orafetch.test: Total 2 Passed 2 Skipped 0 Failed...
We are going to upgrade oracle database from 11.2.0.4.0 to 19.x Currently we are using 8.5.13 version for TCL Will current version of TCL work with 19.x Oracle database? or we will need to update it? OS : Solaris 10
Maybe make a special support call available to ask for the information? On Tue, Mar 26, 2019 at 2:34 PM Todd Helfter tmh@users.sourceforge.net wrote: first clue: oci.h : #define OCI_FNCODE_LOBLENGTH2 114 Instead of the oracols.test using a hard coded value of 86, I should see if I can determine the lob length programatically. Oratcl 4.6 on Oracle 18c https://sourceforge.net/p/oratcl/discussion/40540/thread/15201430d9/?limit=25#85be Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/oratcl/discussion/40540/...
first clue: oci.h : #define OCI_FNCODE_LOBLENGTH2 114 Instead of the oracols.test using a hard coded value of 86, I should see if I can determine the lob length programatically.
I have just attempted to run the test suite for Oratcl against 18c for the first time. tcl : 8.6.7 oratcl : 4.6 oracle client : 18.3.0.0.0 (x86-64 linux) oracle database : 18.0.0.0.0 (x86-64 linux) I'm seeing errors in these tests: oracols.test oradesc.test oralob.test arraydml.test This appears to be related to the size of a lob_locator being increased from 86 to 114. I will begin remediation efforts to see what has changed and provide a patch.
I have not seen this error before, but have not used 10g in a very long time. 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. -Todd
Anybody got the ORA-24315 error when doing oralogon ? And know a resolution? I do: set lda [oralogon bmssa/bmssa_pwd@AX30TEST] Then Oratcl returns ORA-24315: illegal attribute type I have done a lot of SQLNET trace, strip down the TNS, ... ect., but no luck. The enviroment is Oracle 10g on windows and Oratcl46.dll. The Oratcl is part of the HammerDB test tool. I do not know if Oratcl46.dll was compiled by them. So as long I have this error, I can not use the HammerDB test tool, and benchmark my new...
add function ::Oratcl::utils::getLogo to Expose the oratcl powered logo for external use
Tests to exercise the basic Oratcl commands
Tests the orabindexec command
Added notes on using Oratcl with Tcl8.1
Tests the insertion of tables and columns with internationlizationed characters
Contains instructions and info on running test suite
This commit was manufactured by cvs2svn to create tag 'oratcl-2-5'.
initial check-in of Oratcl 2.5
Added changes for Internationalization
Added changes to compile with Tcl8.1 and stubs library.
Generates TEA configure file for shared libraries only
Initial check in of Oratcl man page
Tests the orafetch command with internationalized strings
Tests the oraplexec command with internationalized strings
Standard project directories initialized by cvs2svn.
DLL for Oratcl version 2.6 which has been modified for Internationlization and uses stubs library.
Second test file to test internationization of Oratcl
First test file containing tests for internationization of Oratcl
tests the oraplexec command
Tests the orabindexec command with internationalized strings
Generates TEA Makefile for shared libraries only
Changed connect string to or8i. Note this connect string may change in the future and this test will no longer work
Minor bugfixes to get oratcl to build in a TEA environment.
Contains definitions needed for Oracle 8 OCI API
Added for TEA
Added require TEA file
Makefile.in: Install OCIW32.DLL temporarily to "fake" an oracle installation
Added check for ora803.lib which is needed when using Oracle 8 OCI
Changed connect string to or8i. THis connect string may change in the future andthis test will not work
Oracle env vars now set in test
Needed for TEA
Changed connect string to or8i. This connect string may change in the
Copied newer version from sample TEA extension
Removed commands that were trying to install 0 header files.
Fixed bug with variable x declaration. Also changed connect string to or8i
Oracle env variables now set in test
fixed a bug for logging off oracle
Changed connect string to or8i. This connect string may change in the future and this test will no longer work.
Updates to insert compile flag for Version 7 Databases
Added compile flag for using version 7 Oracle database
Added notes on Oratcl2.6 and brief explanation on how to build Oratcl using TEA
Oracle dll needed so that Oratcl can run. This should come with
Removed conditional code to set NLS_LANG environment variable
pkgIndex.tcl should be installed into the correct directory now.
Added drop procedure statement for PL/SQL statement created in this test.
New pkgIndex file template. Auto-generating the pkgIndex file was just
Fixed a bug in SHLIB_LD_FLAGS
Oracle env vars now set in script
OCIW32.DLL now installed into the correct location
Changes for using OCILogin call from Oracle 8 OCI API instead of ologon from Oracle 7 API. This change enables Oratcl to work with Oracle 8i.
Removed installation of non-existent "oratcl.h"
Fixed bug when running mkIndex.tcl
Removed config.status: and configure: targets from Makefile
OraTcl warnings have been fixed.
fixed bug for logging off oracle. Changed connect string to or8i which will allow connection to the oracle 8i db on uncle. Note: this connection string is subject to change in the future.
changed connect string to or8i. This string may change in the future
Fixed a bug in install target
Oracle env variables now set in script
Oracle env vars, now set in script
Changed using ora803.lib to oci.lib
Addwd Oratcl 2.6 info
Reverted to older dll without NLS_LANG set
Oracle env var now set in script
Changes to put #ifdef's around OCI8 calls
This commit was manufactured by cvs2svn to create tag 'scriptics-sc-1-0'.
Contains system specific Oracle data (logon name, password connection string) and also sources Oratcl and test packages
Removed system specific info such as Oracle logon name and sourced defs.tcl instead
Sources Oratcl test files
Fixed bug to check for ealier Oracle version of libclient.a
added test target
This commit was manufactured by cvs2svn to create tag 'scriptics-
This commit was manufactured by cvs2svn to create tag 'scriptics-sc-1-1'.
Put back variable OTHER_LD_SEARCH_FLAGS so users do not have to have LD_LIBRARY_PATH set in their environment.
Fixed bug when using the Oratcl 8 API calls for login and logoff.
This commit was manufactured by cvs2svn to create tag 'scriptics-sc-1-1-b1'.
Fixed quoting around oracle library names so that if the oracle libs are
Test for logon/logoff problem that occurred when using the Oracle 8 API calls
This commit was manufactured by cvs2svn to create branch 'scriptics-
Removed flag that caused NLS_LANG variable to be set
This commit was manufactured by cvs2svn to create tag 'scriptics-bc-1-0-b1'.
Added support for building under Win95/98 using cygwin
Updated to reflect recent TEA changes
Updated to reflect recent TEA changes
Updated to reflect recent TEA changes
This commit was manufactured by cvs2svn to create branch 'scriptics-
This commit was manufactured by cvs2svn to create tag 'scriptics-
Updated to reflect recent TEA changes
This commit was manufactured by cvs2svn to create tag 'ajuba-ajuba2-2-0'.
Rearranged build/install files to use a shared config module
This commit was manufactured by cvs2svn to create tag 'scriptics-sc-2-0-b2'.
First batch of changes to convert Oratcl2.6 to Oratcl2.7