ORATCL help needed!
- From: mets <tony_metters@xxxxxxxxxxx>
- Date: Fri, 01 Jun 2007 06:24:54 -0700
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?????
.
- Follow-Ups:
- Re: ORATCL help needed!
- From: thelfter@xxxxxxxxx
- Re: ORATCL help needed!
- From: Volker Hetzer
- Re: ORATCL help needed!
- Prev by Date: Re: Would like to help out...
- Next by Date: Re: Seeking a rich text editing widget
- Previous by thread: Re: PROPOSAL: Tcl equivalent to .NET interop
- Next by thread: Re: ORATCL help needed!
- Index(es):
Relevant Pages
|
