472,364 Members | 2,087 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,364 software developers and data experts.

reading text using client_text_io utility

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 under HP UX,
Application Server release under RH Linux, reports and Forms
Generated by Dev9i

Please reply to me as soon as possible
Oct 5 '08 #1
7 22660
8,127 Expert 4TB
try to disable any index on the tabl;e during data loading process and enable the same alter on during data fetch process.
Oct 5 '08 #2
Thanks for your reply
we are using this method and do not work probably
I think problem raised from application not from sql insert into statement
Can you tell me how can I trace the application and find where it hang.
Oct 6 '08 #3
8,127 Expert 4TB
how i will know what are you doing in your application ?
Oct 7 '08 #4
the application trying to read a text file (line by line) located on PC and insert the records into a table in the database
the application use client_text_io utility (WEBUTIL) to read the file
Oct 7 '08 #5
if you ask about the code
we are using the following code:
DELETE FROM tableName;
in_file := client_text_io.fopen(:file_path,'r');
when no_data_found then
MESSAGE('empty file');
V_var1 := nvl(substr(linebuf,1 ,10 ),0);
V_var2 := nvl(substr(linebuf,12 ,2 ),0);
V_var3 := substr(linebuf,15 ,10 );
V_var3 :=trim(V_var3);
IF V_var3 = '' THEN
V_var4 :='';
V_var4 := TO_NUMBER(V_var3) ;
end if;
V_var5 := substr(linebuf,26 ,70 );

INSERT INTO tableName VALUES (V_var1,V_var2,V_var4,V_var5);

end loop;
Oct 7 '08 #6
thanks for your replying
finally we find a solution and it is so simple
set a parameter in java initiator on the client
go to the java initiator in control panel and fill the following
-mx256m -Dcache.size=20000000
in the java runtime parameter field
thats mean the JVM on the client can use 256 mega from the PC RAM
Oct 14 '08 #7
Use webutil_file_transfer.client_to_as to copy your file to app. server
and after that use text_io instead of client_text_io.
Dec 9 '08 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Richie | last post by:
I'm trying to write a VB.net (VB.Net 2005 Express) application that scans open applications for certain words or phrases. I've successfully managed to get it to read textboxes, labels, etc in...
by: Bishman | last post by:
Hi, I have been trying to get text to scroll smoothly accross a windows form using GDI+ and a timer. Changing the position of the text by a configurable amount and calling invalidate to force a...
by: nskclr | last post by:
Hi I add a text using document.selection.createRange(). I want to add a text to the bottom of another text - similar to what we do in HTML. <p> xyz </p> <p><div...
by: anilraja | last post by:
how to search within text using vbscript?
by: f6600840 | last post by:
Hi, What function I should use if I want to clean text using perl. Example. Input for my perl based shell command is SMI-1234 566. = "huuhaa" : SMI-1234...
by: jasvinder singh | last post by:
Respected Sir/madam, Can you help in providing code in 'C' for Reading text file with n number of rows and columns and putting the result in arrays.The sample file is as follows: rim_label =...
by: RuthC | last post by:
How to create a warped text using javascript? Is it possible..? pls help me ...
by: Hamayun Khan | last post by:
Hi All I have text files having queries like below. INSERT INTO tblJobScrap (,,,,,,,,,) VALUES...
by: research_stuff | last post by:
I have researched unhiding text using Javascript. I found examples unhiding text boxes. I need to unhide text when a radio button has been selected. Can someone point me to an example? ...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.