Tcl - Announce:: Oratcl 4.4 now available on sourceforge.net

Author

Announce:: Oratcl 4.4 now available on sourceforge.net

thelfter@gmail.com

2006-05-18, 7:10 pm

Hello,

This is a quick notice to the oratcl community that a new Source
download and Windows prebuilt binaries are available for Oratcl.

Version 4.4 has the following major improvements as well as several
fixes. These are all listed in the ChangeLog file located in the
source download.

Threading:: With the help of Steve Shaw (the hammerora maintainer) and
his valueable assistance, we have eliminated several errors that were
occuring on very fast systems with multiple dual core processors.

Oracle Version: The package has been changed to recognize an
ORACLE_LIBRARY environment variable. This helps alleviate package
loading complications that we had on combined 32bit/64bit systems and
also with different library locations that came about with the release
of Oracle instant client.

Additional Platforms: I spent a considerable amount of time makeing
sure that Oratcl 4.4 works on Linux x86-64 with Oracle 10g R2 (64 bit).
It also works on x86 linux using the 10gR2 instant clients. (with the
ENV variable above set to ../instantclient_10_2/libclntsh.so.10.1

LOBs: Oratcl 4.4 supports the direct reading and writing of blob and
clob columns using SQL. It is now possible to use sql like 'select
clob1, clob2, clob3, clob4 from table_with_clobs' and 'update
table_with_clobs set clob1 = :c1' etc. There are still limitations
however. Depending on the platform there are limits to how big a
Tcl_Obj may grow. I have had little trouble with CLOBS under the 2G
range. You will want to carefully consider your 'oraconfig' settings.
Best if you look at the tests/oralob.test file in the source tree for
examples. I've found that lob piecewise operations of 1,000,000 (1
million) characters work quite well on 64bit linux.

New subcommand [orainfo client]
This command will return 0.0.0.0.0 if the client version is not 10g
or higher.
The OCI function does not exist in the 8i and 9i libraries.

If you have any bug reports, questions or suggestions, stop by the
sourceforge page.

Thanks
Todd Helfter

Robert Hicks

2006-05-18, 7:10 pm

Thanks for your work Todd!

Robert

lvirden@gmail.com

2006-05-22, 8:06 am

According to thelfter@gmail.com <thelfter@gmail.com>:
:This is a quick notice to the oratcl community that a new Source
:download and Windows prebuilt binaries are available for Oratcl.

Anyone out there using Oratcl on SPARC Solaris?

For years now I've encountered the same problem. I have to hand edit
the Makefile generated by oratcl to add in -R, -L, and -l flags for
1-2 additional oracle libraries. These are libraries that the client library
uses. Since the oracle libraries do not, at least at my shop, get installed
in /usr/lib or even /usr/local/lib , extra work has to go on to allow
oratcl to find them.

I'm wondering whether there is some other way for me to pass that info
along to oratcl during configuration and build.
--
<URL: http://wiki.tcl.tk/ > Indescribable,uncontainable,all powerful,untameable
Even if explicitly stated to the contrary, nothing in this posting
should be construed as representing my employer's opinions.
<URL: mailto:lvirden@gmail.com > <URL: http://www.purl.org/NET/lvirden/ >

thelfter@gmail.com

2006-05-23, 8:06 am

Hello, SPARC solaris is my development platform. I have not had to
hand edit a makefile for years. Oratcl does not even need Oracle
installed to compile. It does depend on the ORACLE_HOME environment
variable, and now to a lesser extent a new ORACLE_LIBRARY environment
variable.

Sponsored Links