Home » Developer & Programmer » Forms » Client_text_io (ORACLE forms 10G (9.0.4))
Client_text_io [message #280624] Wed, 14 November 2007 04:33 Go to next message
kenjio
Messages: 7
Registered: November 2007
Junior Member
hi,
I have a problem in Client_text_io.fclose,Im loading ascii file thru forms and insert data to oracle table, after all the records is inserted successfully,the application is hanged without any error message. i try to comment out this codes below to test if client_text_io is working:
exception
when no_data_found then
CLIENT_TEXT_IO.fclose(file_handle);
when others then
message(sqlerrm);
but it gives me the error ORA-01403 - no data found;
the webutil configuration is working fine and no error is detected on my java console.
Anyone can help me this..thanks in advance.

Kenji
Re: Client_text_io [message #281177 is a reply to message #280624] Fri, 16 November 2007 00:10 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Before doing the close, test as to whether the file is still open.

David
Re: Client_text_io [message #281483 is a reply to message #281177] Sat, 17 November 2007 04:31 Go to previous messageGo to next message
kenjio
Messages: 7
Registered: November 2007
Junior Member
Thanks for the reply david, I already solved the problem.

Kenji
Re: Client_text_io [message #281484 is a reply to message #281483] Sat, 17 November 2007 05:57 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

Then also post your solution, it will help others to solve this problem if they get...

Cheers
Soumen
Re: Client_text_io [message #281539 is a reply to message #281484] Sun, 18 November 2007 01:24 Go to previous message
kenjio
Messages: 7
Registered: November 2007
Junior Member
Ive done it by placing the exception when no_data_found and when others statement inside the loop.

Kenjio
Previous Topic: I want file lar.pll and lar.jar
Next Topic: pre-form
Goto Forum:
  


Current Time: Fri Dec 09 02:15:01 CST 2016

Total time taken to generate the page: 0.24995 seconds