Hello,
We have a window that establishes a connection to EAServer, and gets a reference to an NVO (#1) on that server. The NVO (#1) creates a datastore NVO (#2).
A button on the window calls a method on NVO #1, which uses NVO #2 to retrieve data. (We're trying to use setFullState / GetFullState ).
The first retrieve always works and no dberror message is returned. Around the third retrieve, however, only some of the rows are returned and we get the "ORA-24388: statement handle not executed" error returned from the dbError event of the datastore NVO.
All subsequent retrieves also give that error.
Re-deploying the NVO #1 fixes things.
Or, having the NVO #1 disconnect and reconnect when the retrieve() fails fixes things ... for a single retrieve.
It feels like we are running into some resource limit ... but I don't know what the limit is.
When the retrieve works, we get 180k rows, and have a blob of 26mb. When the retrieve fails ... we have some number of rows less than 180k ... it varies.
We've done a bunch of googling ... but haven't found anything that looked appropriate.
Thanks,
LR
We have a window that establishes a connection to EAServer, and gets a reference to an NVO (#1) on that server. The NVO (#1) creates a datastore NVO (#2).
A button on the window calls a method on NVO #1, which uses NVO #2 to retrieve data. (We're trying to use setFullState / GetFullState ).
The first retrieve always works and no dberror message is returned. Around the third retrieve, however, only some of the rows are returned and we get the "ORA-24388: statement handle not executed" error returned from the dbError event of the datastore NVO.
All subsequent retrieves also give that error.
Re-deploying the NVO #1 fixes things.
Or, having the NVO #1 disconnect and reconnect when the retrieve() fails fixes things ... for a single retrieve.
It feels like we are running into some resource limit ... but I don't know what the limit is.
When the retrieve works, we get 180k rows, and have a blob of 26mb. When the retrieve fails ... we have some number of rows less than 180k ... it varies.
We've done a bunch of googling ... but haven't found anything that looked appropriate.
Thanks,
LR