We are using client_text_io utility (webutil.pll) to read a text file and insert specific fields into table in the database
Problem: firstly the read and insert performance is too fast, when the number of records increase the performance become slowly, finally the application hang.
When we are using another utility (UTL_FILE) in a stored procedure on the database directly, the operation works probably.
But we must use (webutil.pll)
We are using Oracle Application Server to deploy our application which
Contains forms and reports.
Where we use Oracle9i Enterprise Edition release 9.2.0.1.0 under HP UX,
Application Server release 9.0.4.0.0 under RH Linux, reports and Forms
Generated by Dev9i
Please reply to me as soon as possible