Intermittent problem reading records with QTP and Oracle

[David.Wiltshire at wincanton.co.uk]

All,

I have an intermittent problem with QTP adding records, and then SQL being 
not able to read all the records. 

The QTP has multiple requests, the commit is at run.  In one of the 
requests it adds 1 record to table A and 1 record to table B.  In the next 
request it calls a stored procedure which reads the record on table A but 
is unable to read the record on table B.  It seems like some sort of 
timing issue but makes no sense to me.

The Powerhouse version is 8.43d1.
The Unix version is AIX 5.3.0.
The Oracle version is 10.0.1.0.2.0.

Has anyone come across this problem before?  If so was you able to resolve 
it?

The problem is bigger than not being able to read records from SQL.  I 
have had the same problem before where 10 records get added to table A in 
one request and in the next request it only reads 5.  I was able to get 
around this by writing the records to a subfile as well as the table and 
then in the next request access the subfile instead of the table.  That 
suggests that it is some sort of problem between Oracle and QTP.

Many thanks,
Dave Wiltshire

***************************************************************
Wincanton plc is a leading European provider of supply chain solutions.  We design, implement and operate creative solutions for customers in 15 countries.  Our business has a turnover of over EUR2.4bn /1.68bn pounds and employs 27,000 staff across 360 locations.  Warehousing, transport and specialist services are provided for customers in a range of sectors including automotive, retail, FMCG, petrochemicals and manufacturing.  Further information on our unique achievements and competencies can be found by visiting 

www.wincanton.co.uk

****************************************************************
This e-mail and any files transmitted with it are confidential 
and intended solely for the use of the individual(s) to whom it 
is addressed.  If you have received this e-mail in error please 
contact IT Service Desk on +44 (0) 870 870 9393 or e-mail
mail.monitor at wincanton.co.uk

Any views or opinions expressed are solely those of the author 
and do not necessarily represent those of Wincanton plc
or any of its subsidiary companies.  Unauthorised publication, 
use, dissemination, forwarding, printing or copying of this 
e-mail and its associated attachment(s) is strictly prohibited.
Wincanton plc, Methuen Park, Chippenham, Wiltshire SN14 0WT.
****************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060112/9c08452e/attachment.html