QTP and SQL stored procedures

Kevin Erne kevin.erne@lineone.net
Wed, 14 Aug 2002 20:19:46 +0100


Running QTP V8.13D on AIX. The QTP has no commit statements and uses serializable
CONSISTENCY transaction for every table accessed. Calling Oracle (V8.1.7)
stored procedure in very last request. If this fails e.g. constraint violation
- then previous updates are still committed. 
This QTP is usually run in a batched ksh script and tests $? after  QTP
is invoked. This seems to think that QTP has worked fine even after stored
proceduree has failed. Is this a bug/feature?