Forum OpenACS Development: Re: Oracle issue with acs-tcl package 5.10.1 official

Collapse
2: Re: Oracle issue with acs-tcl package 5.10.1 official (response to 1)
Posted by Brian Fenton on 03/14/25 10:40 AM
Hi Jonathan

I'm not in a position to confirm your fix, but just wanted to point out that the the using the colon instead of the dollar may work well too (better in fact because it should take advantage of Oracle's bind variable performance optimization):

lappend arguments "$argument_name => :argument_value"

best wishes
Brian Fenton

Collapse
3: Re: Oracle issue with acs-tcl package 5.10.1 official (response to 2)
Posted by Jonathan Kelley on 03/17/25 01:44 PM
Hi Brian,

Thanks for the response but what I didn't include was the value of $argument_value is the result of this call:

set argument_value [:dbfunction_argument_value -name $argument_name -type $type]

In this `dbfunction_argument_value` it has this logic

if {[dict exists [:typemap] $type]} {
string cat CAST(: [string tolower $name] " AS " $type )
} else {
string cat : [string tolower $name]
}

So the result ends up being multiple `:` characters preceding the variable name which is the cause of the error.

Best,
Jon

Collapse
4: Re: Oracle issue with acs-tcl package 5.10.1 official (response to 3)
Posted by Gustaf Neumann on 03/17/25 03:46 PM
Jonatan, i your solution looks right to me, but i could not test it so far. If it works for you, just go on with this for the time being.
-g