OraFAQ Forum: Forms » excel to form 10g

Home » Developer & Programmer » Forms » excel to form 10g

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

excel to form 10g [message #218779]

Sat, 10 February 2007 02:51

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

.................

Report message to a moderator

Re: excel to form 10g [message #218780 is a reply to message #218779]

Sat, 10 February 2007 03:00

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

Report message to a moderator

Re: excel to form 10g [message #219140 is a reply to message #218779]

Tue, 13 February 2007 02:48

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: excel to form 10g [message #220075 is a reply to message #219140]

Sun, 18 February 2007 11:28

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);

Report message to a moderator

Re: excel to form 10g [message #224926 is a reply to message #220075]

Thu, 15 March 2007 23:18

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

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 21:19:57 CST 2025