OraFAQ Forum: Forms » Uploading from Excel stopd when I open the file

Home » Developer & Programmer » Forms » Uploading from Excel stopd when I open the file (Oracle forms 10G, windows XP, webutil)

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

Uploading from Excel stopd when I open the file [message #480093]

Thu, 21 October 2010 03:13

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

I'm uploading data from excel to our database using forms thru webutil. The problem is when I open the same excel file while the upload process is in progress, the uploading stops, BUT not displaying any error. Not even when I chick Help->Show error.

How could I prevent this error and how to trap and display error message?

Report message to a moderator

Re: Uploading from Excel stopd when I open the file [message #480233 is a reply to message #480093]

Thu, 21 October 2010 21:37

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

I also get this error on java console.

2010-Oct-22  10:28:16.500 ERROR>WUO-714 [OleFunctions.setExceptionValues()] Unable to get the last OLE Error details; Exception
null

2010-Oct-22  10:28:16.500 ERROR>WUO-709 [OleFunctions.get_obj_property_args()] Unable to get Property: Cells; Exception
com.jacob.com.ComFailException: A COM exception has been encountered:
At Invoke of: Cells
Description: An unknown COM error has occured.

Report message to a moderator

Re: Uploading from Excel stopd when I open the file [message #481650 is a reply to message #480233]

Fri, 05 November 2010 00:11

tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka

Senior Member

Dear wency,
you don't access your excel file while your upload process is running. you have to access excel file after uploading is complete.
Because oracle forms using OLE(Object Linking Embed) tools for upload data from excel. OLE function unable to get data from excel
while any other access the same file. u use a status value in your forms developer so that u can ensure your data uploading is
complete or not.

regards,
Tamzidul Amin.

Report message to a moderator

Re: Uploading from Excel stopd when I open the file [message #481668 is a reply to message #481650]

Fri, 05 November 2010 02:44

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Thanks!

I already have my trap on that to notify the user upon opening of file on process.

Cheers! Smile

Report message to a moderator

Re: Uploading from Excel stopd when I open the file [message #481920 is a reply to message #481668]

Mon, 08 November 2010 06:13

imoeckel
Messages: 5
Registered: November 2010
Location: Germany

Junior Member

Hello Wency,

I get the same error. What did you do?

Thank you Ines

[Updated on: Mon, 08 November 2010 06:13]

Report message to a moderator

Re: Uploading from Excel stopd when I open the file [message #482124 is a reply to message #481920]

Tue, 09 November 2010 21:03

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

I placed a marker everytime I read the value from excel, like this:

v_isopened := 'Y';
cell_value := Client_OLE2.get_char_property(cell,'Value');
v_isopened := 'N';

In my EXCEPTION, I can now display message that the file was opened so it terminates.

Also, place these for other error that may occur:

displaymessage(Error_code||': '||Error_text || '.');
displaymessage(SQLERRM);

[Updated on: Tue, 09 November 2010 21:04]

Report message to a moderator

Re: Uploading from Excel stopd when I open the file [message #482131 is a reply to message #482124]

Tue, 09 November 2010 23:08

AleciaBrent
Messages: 15
Registered: August 2008

Junior Member

Even I got same error but what "tamzidulamin" said and what "wency" applied I followed same by reading this thread...

------
e-discovery case management
Ediscovery software

[Updated on: Tue, 09 November 2010 23:12]

Report message to a moderator