Stmt Handle has not been allocated (NULL)
I am doing database testing. The protocol is oracle(2tier). I am trying to parameterize and run script for 2 iterations. First set of values are inseritng into database table. And for the second iteraion above message is coming and it was ending. I opened seperate .dat files for each value. could anyone reply
I think that at the end of your Action() you release the handle with "lrd_handle_free(&OraStm3, 0)" (OraStm3 is an example only, yours may be named differently).
What happens is you allocate this handle in the beginning of the script (I am guessing it is probably in your vuser_init) with lrd_ora8_handle_alloc(OraEnv1, STMT, &OraStm3, 0), and thus for the 2nd iteration it has already been freed.
Try to move the lrd_handle_free statement to the vuser_end and see if it helps you.
Otherwise allocate and free the handle within the action itself.
I tried these two options. I am missing something. Now the error for second iteration as follows.
Action.c(7): Error: lrdo_ora8_exec: "OCIStmtExecute" return-code=OCI_ERROR, error-code=01012:
Action.c(7): Error: ORA-01012: not logged on
Action.c(7): ora8_exec: ERROR, return-code=LRDE2009. 0 row(s) processed
will you look into that
Yes I got it. I tried the way u advised.
I allocated and freed the handle in action part.
It worked. Many many thanks. Hope you will continue u r experiences in this forum. I appriciate u r valuable time and suggestion.