Re: ORATCL help needed!

On 6 Jun, 13:27, "thelf...@xxxxxxxxx" <thelf...@xxxxxxxxx> wrote:
On Jun 1, 9:24 am, mets <tony_mett...@xxxxxxxxxxx> wrote:





Hi,

I have re-invigorated my interest in TCL + extensions after a 5 year
absence. I have rewritten some old HPUX apps to run on Windows 2000,
Tcl8.4 using Oratcl 4.4 / 3.3

Problem1:

I am unable to use Oratcl 4.4 because it reports a nasty application
error (NOT a TCL error) during the command 'oralogon'. Now I assume
this is because I am trying to use it with the OCI 8.0 client
libs ???

Problem 2:

I am able to use Oratcl 3.3 but it reports ORA-01007 "variable not in
select list" whenever I change the sql select string and use the SAME
cursor variable. For example:

# open the channel
set cursor [ oraopen $handle ]
orasql $cursor "select COL1 from TABLE where SOMETHING"
# This executes as expected.

orasql $cursor "select COL1,COL2 from TABLE where SOMETHING"
returns the error ORA-01007

I notice the ONLY way to get multiple select statements to work is by
repeatedly closing the cursor and then opening the cursor. It seems as
if the previous SQL statement is not cleared from the cursor internal
state???

any help?????

Wow, An Oratcl 3.3. help request. Sorry but thats the first one of
those I've gotten in over 5 years.

First of all. There is no way that any Oratcl 4.x will ever work with
OCI 8.0 libs. It is coded with the the OCI layer released with Oracle
8i.

Second.. I remember this, there were several bugs in the OCI 8.0
versions that affected Oratcl.

Third.. Re-using statement handles has been part of Oratcl for many
many years. I do it all the time.

Why OCI 8.0?
Oracle instant client is available for many many platforms, have you
tried any of those?
Is the destination database also 8.0?
Did you compile Oratcl 3.3 for yourself.
Is your Oracle client 8.0 patched with all the patches available from
oracle?
What OS and Tcl version are you using?

-Todd- Hide quoted text -

- Show quoted text -

BACKGROUND:
Our production process is using Oracle 7.3.4 ! As you can image it is
due an upgrade. I believe we will move to 10g.
I loved working with TCL/Oratcl all those years ago and after slogging
to write a couple of forms with C++ and MFC thought
why not look at TCL again. So I began the development with ActivetTcl
8.4 and stuff.


I guess ultimately I need to install the 10g Client. I want to be able
to wrap the files up and distribute them. I have a trial license on
the TclDevKit application. (tho I am not sure if the Oratcl3.3 is
stubs enabled or not?)

Will the 10g client allow me to connect to 7.3.4 server? It may be
easier to migrate to Oratcl4.4 in the meantime!

FYI .....

I am using a precompiled binary of Oratcl 3.3 I think I got it from
sourceforge?
Oracle8 Client 8.0.4.0.0
Windows2000 Service Pack 4

many thanks
Tony



.

Relevant Pages

  • Re: ORATCL help needed!
    ... set cursor ... It is coded with the the OCI layer released with Oracle ... Oracle instant client is available for many many platforms, ... Did you compile Oratcl 3.3 for yourself. ...
    (comp.lang.tcl)
  • [Announce]:: Oratcl 4.3 has been released
    ... Oratcl 4.3 introduces a new approach to compiling and execution. ... It is no longer necessary to have Oracle libraries installed on ... Oratcl 4.3 will dynamically load the relevant Oracle libraries at run ... It be possible to use a single installed version of Oratcl 4.3 with any number of 8i, 9i or 10g Oracle installs on the same machine, To switch the Oracle install used, alter the ORACLE_HOME env variable. ...
    (comp.lang.tcl)
  • Re: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch wont install
    ... Currently all my Oracle inst client files are user oracle group oinstall yet lib bin and other dirs have 755 permission so root should be able to access and execute these softlibs. ... As I have written, I have installed DBD::Oracle-1.19 many times with a full client without problem, yet with the limited instant client it does not find the mk file, and the one mk file that the instant client installs does not work. ... It also gives me a makefile for DBD::Oracle but install and test fail ...
    (perl.dbi.users)
  • Re: DBD::Oracle / Instant Client segfaults
    ... I've been doing some more tests concerning this issue and it seems that it only appears with the combination of Oracle Instant client libraries, Perl configured with -Dusemymalloc on RHEL 3. ... When i run the script with the 'use Digest::SHA1;' line commented ...
    (perl.dbi.users)
  • Re: ... after Opening a record set
    ... I will point out that as long as one can live with a client cursor (all records retrieved to the client machine during the ... it is better to loop based on EOF unless there is a compelling reason to do otherwise. ... >> It is not a reliable method of retrieving records from a recordset. ...
    (microsoft.public.vb.database.ado)