OraFAQ Forum: Forms » Client_text_io

Home » Developer & Programmer » Forms » Client_text_io (ORACLE forms 10G (9.0.4))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Client_text_io [message #280624]

Wed, 14 November 2007 04:33

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

Report message to a moderator

Re: Client_text_io [message #281177 is a reply to message #280624]

Fri, 16 November 2007 00:10

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Before doing the close, test as to whether the file is still open.

David

Report message to a moderator

Re: Client_text_io [message #281483 is a reply to message #281177]

Sat, 17 November 2007 04:31

kenjio
Messages: 7
Registered: November 2007

Junior Member

Thanks for the reply david, I already solved the problem.

Kenji

Report message to a moderator

Re: Client_text_io [message #281484 is a reply to message #281483]

Sat, 17 November 2007 05:57

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

soumen.kamilya@gmail.com

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

Cheers
Soumen

Report message to a moderator

Re: Client_text_io [message #281539 is a reply to message #281484]

Sun, 18 November 2007 01:24

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 21:50:16 CST 2025