[Sqlrelay-discussion] number of binding variables problem

[Laurent C. <lau...@sm...>]

Hi,
I'm using sqlrelay 0.35-10 with an oracle8 database (i recompile the
debian package with oracle8 support) and have a problem with queries
that use a lot a binding variables (more than 256). The program is in
python and use the debian python2.3-sqlrelay 0.35-10 package.

i must make an update of a list of keys (between 10 and 1000+) and build
a query like this:

UPDATE table SET datevalue=sysdate WHERE key IN ( :value_1, value_2,
value_3, .... , value_x)

The i do an inputBind for each value_x.

The query is run successfully when i have less than 256 bindings but
failed with an oracle exception: 'ORA-01008: not all variables
bound\n\nAttempted Query:\nUPDA....

It works perfectly with cxoracle previously used.
Is this a known limitation (i didn't find anything about this) ? I
didn't see anything related to this in the 0.36.x changelog so i don't
check with this version.

I can bypass the limitation with a lot of rebindings but this is 2 times
slower with only 256 bindings.

Thanks.
-- 
Laurent Corbes - lau...@sm...
+33 (0)1 4996 6319
Smartjog SA - http://www.smartjog.com/