[Sqlrelay-discussion] Oracle error (ORA-01036)
Brought to you by:
mused
|
From: Jason M. <jmc...@gm...> - 2007-07-06 21:27:23
|
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 |