Home » Developer & Programmer » Forms » Ora - 105100
Ora - 105100 [message #541802] Thu, 02 February 2012 06:12 Go to next message
felipecabral1451
Messages: 9
Registered: March 2011
Location: Brazil
Junior Member
Hello all.

It's my first post and i need a help, if you can help me i will be grateful for this.

I have a forms that generate a file from database into database server and copy it to client machine by the follow process:
IF webutil_file_transfer.Is_AS_readable(V_server_way || V_file_name) THEN
	    
	    l_success := webutil_file_transfer.AS_to_Client
			(clientFile => :V_screen_way
			,serverFile => V_server_way || V_file_name
			);
	    
			if l_success then
				SET_ALERT_PROPERTY('ALMSG',ALERT_MESSAGE_TEXT, V_RETURN);
		   	V_AUX:=SHOW_ALERT('ALMSG');
			else
				SET_ALERT_PROPERTY('ALMSG',ALERT_MESSAGE_TEXT, 'FILE COPY ERROR'			  ) V_AUX:=SHOW_ALERT('ALMSG');
			end if;
	ELSE
		SET_ALERT_PROPERTY('ALMSG',ALERT_MESSAGE_TEXT,'FILE READ ERROR');
	 	V_AUX:=SHOW_ALERT('ALMSG');
	END IF;


But is showing the erro ora-105100 in one client machine, can anyone help me?
Re: Ora - 105100 [message #541803 is a reply to message #541802] Thu, 02 February 2012 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure of your error number?
Post the complete error message.

Regards
Michel
Re: Ora - 105100 [message #541806 is a reply to message #541803] Thu, 02 February 2012 06:27 Go to previous messageGo to next message
felipecabral1451
Messages: 9
Registered: March 2011
Location: Brazil
Junior Member
I've uploaded the image, but i can`t post links, because i don`t have 5 messages. But its exaclty this error!



Re: Ora - 105100 [message #541807 is a reply to message #541806] Thu, 02 February 2012 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Try to copy and paste in text mode if possible
2/ If no possible, click in the Reply button (instead of using "Quick Reply") then you can upload the image here.

Regards
Michel
Re: Ora - 105100 [message #541809 is a reply to message #541807] Thu, 02 February 2012 06:59 Go to previous messageGo to next message
felipecabral1451
Messages: 9
Registered: March 2011
Location: Brazil
Junior Member
trigger whem-button-pressed levantou a exceção ora-105100 não tratada

The forms language is portuguese!
Re: Ora - 105100 [message #541810 is a reply to message #541807] Thu, 02 February 2012 07:01 Go to previous messageGo to next message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
Michel Cadot wrote on Thu, 02 February 2012 12:36
1/ Try to copy and paste in text mode if possible

It generally isn't with forms.

ORA-105100 is, from memory, a generic problem with external program type of error.
Put messages in the trigger to work out which exact line is causing it. I imagine it's one of the two calls to webutil_file_transfer.
Re: Ora - 105100 [message #541811 is a reply to message #541810] Thu, 02 February 2012 07:16 Go to previous messageGo to next message
felipecabral1451
Messages: 9
Registered: March 2011
Location: Brazil
Junior Member
The erro occurs aways in the morning and not all the time, and when the client restart the browser everything is ok and she can generate the file.

In this morning he error was 'FILE COPY ERROR', the ora-105100 happened yesterday.

Look:

http://img859.imageshack.us/img859/6605/image2mt.jpg

[Updated on: Thu, 02 February 2012 07:20]

Report message to a moderator

Re: Ora - 105100 [message #541812 is a reply to message #541811] Thu, 02 February 2012 07:28 Go to previous messageGo to next message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
Like I say it's a generic error.
Could be file permission problems, network issues, anything that could prevent webutil_file_transfer working.
Re: Ora - 105100 [message #541813 is a reply to message #541812] Thu, 02 February 2012 07:40 Go to previous messageGo to next message
felipecabral1451
Messages: 9
Registered: March 2011
Location: Brazil
Junior Member
How can i trace it and have the real error?
Is there any way for it?
Re: Ora - 105100 [message #541849 is a reply to message #541813] Thu, 02 February 2012 12:04 Go to previous message
felipecabral1451
Messages: 9
Registered: March 2011
Location: Brazil
Junior Member
Anyone can help me about it? So hOw can i check the real error?
Previous Topic: DBMS_OUTPUT Messages on Form
Next Topic: go_item doesen't works !
Goto Forum:
  


Current Time: Fri Aug 23 16:08:06 CDT 2024