Ora - 105100 [message #541802] |
Thu, 02 February 2012 06:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/5afab8794af9944b30fec995de316f54?s=64&d=mm&r=g) |
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 #541810 is a reply to message #541807] |
Thu, 02 February 2012 07:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13964 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Michel Cadot wrote on Thu, 02 February 2012 12:361/ 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/5afab8794af9944b30fec995de316f54?s=64&d=mm&r=g) |
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:
[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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13964 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.
|
|
|
|
|