I'm quite new to TOra. I'm used to work with TOAD and PL/SQL Developer but now i'm looking for a free alternative.
While working with TOra I've noticed that in the schema browser binary data like RAW(x) fields are being displayed as binary text. The project I work for now uses RAW(16) columns as PK's throughout the whole database. When browsing tables it would be quite usefull if the schema browser would apply the "RAWTOHEX" function implicitly. If I now want to see a textual representation of a PK/FK I have to use a query windows and create a select statement with the RAWTOHEX function applied on each RAW(16) field… .
There used to be a bug (ID 2944747) but it should be solved.
I use TOra 2.1.3 on a W7 x64 system.
This was fixed in a branch which uses alternative wrapper for Oracle's OCI library.
(I'll try to create a Win32 build of it a will publish it somewhere)
Thx for the reply! Looking forward for a new version :-)
Hi I've uploaded experimental build for win32 into a folder tora-experimental on source forge. It does not have any installer.
It should be executable from any location.
Most of the users who complain about Tora have problems with locating Oracle client libraries. The procedure of detecting and loading Oracle libraries is much more tricky on Windows then on Unix. And since Tora is mainly developed on Linux
no one worked on it to solve it correctly.
In order to use this build you should:
- Download an install "Microsoft Visual C++ 2010 Redistributable Package (x86)"
- Download and install Oracle instant client(11GR2) (32bit version)
- In the system setup set environment variables: PATH, ORACLE_HOME, TNS_ADMIN to point into the directory containing
- Create a file tnsnames.ora in Oracle instant client directory.
I found the download and tried the build. It works! :-)
I can however after clicking "ok" a couple of times, select a stored connection setting and do what i want to do in TOra.
This is just a debugging warning. If you set env. variable TNS_ADMIN to a directory containing file tnsnames.ora it will disappear.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.