Home » Developer & Programmer » Forms » excel to form 10g
excel to form 10g [message #218779] Sat, 10 February 2007 02:51 Go to next message
geetav
Messages: 2
Registered: February 2007
Junior Member
Hi,

I want to transfer data from excel to form10g . is there any setting require for this. excel is office11/2003. Though I tried with OLE2 and installed webutil but it is givng me error frm-40735 / ora-30550 in get_obj_property.


Anyone there who can help Embarassed .................





Re: excel to form 10g [message #218780 is a reply to message #218779] Sat, 10 February 2007 03:00 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Are you have METALINK a/c if yes then search for below error.
ora-30550 in get_obj_property

regards
Taj
Re: excel to form 10g [message #219140 is a reply to message #218779] Tue, 13 February 2007 02:48 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at http://forums.oracle.com/forums/thread.jspa?messageID=1684867&tstart=0

Put a 'message; pause' pair between each command statement so that you can deduce EXACTLY the line that is giving the error/

Post the code please and tell us the EXACT line that gave rise to the error.

David
Re: excel to form 10g [message #220075 is a reply to message #219140] Sun, 18 February 2007 11:28 Go to previous messageGo to next message
geetav
Messages: 2
Registered: February 2007
Junior Member
application:=OLE2.CREATE_OBJ('Excel.Application'); OLE2.Set_Property(application,'Visible', 'True');
workbooks := ole2.get_obj_property(application, 'Workbooks'); (IN THIS LINE IAM GETTING ERROR)
args:= ole2.create_arglist;
ole2.add_arg(args,filename_var);
workbook := ole2.invoke_obj(workbooks, 'Open', args); ole2.destroy_arglist(args); args:= ole2.create_arglist; ole2.add_arg(args, 'Sheet1'); worksheet := ole2.get_obj_property(workbook, 'Worksheets', args); ole2.destroy_arglist(args);

Re: excel to form 10g [message #224926 is a reply to message #220075] Thu, 15 March 2007 23:18 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: Stop execution of a trigger
Next Topic: Unable to update record with sequence number in multiple records block.
Goto Forum:
  


Current Time: Fri Dec 09 00:08:27 CST 2016

Total time taken to generate the page: 0.08820 seconds