[Sqlrelay-discussion] Oracle error (ORA-01036)

[Jason M. <jmc...@gm...>]

I have recently started playing with sqlrelay, and I am getting this error
occasionally.

>From the server side, I am using sqlrelay to connect to an Oracle (10g)
database in a RAC environment. There are two nodes in this cluster. From the
client side, I am using the C API. Just to get a feel for how things work, I
whipped up a quick client program that essentially does the following:

1 establish a connection
2 get a cursor
3 prepare an update query (with bind variables)
4 bind strings to the cursor
5 execute the query
6 commit the transaction
7 clear the bind variables
8 end the session

steps 4 through 8 are repeated a bunch of times with the bind variables
changed on each iteration.

I am running 30 of these clients at a time to get a feel for what each of
the configuration values does.

Occasionally, and unpredictably, the execute fails with an error (ORA-01036:
illegal variable name/number). At this point, I am clearing the bind
variables, ending the session, re-binding, and re-executing until it
succeeds, but that may take several iterations to accomplish.

I am wondering if the prepared statement must be run on a connection to the
same node in the cluster, but I do not know how to confirm that.

Any idea what is causing this, and how to get around it?

Thanks,
Jason