OraFAQ Forum: Forms » Client

Home » Developer & Programmer » Forms » Client_ole2 problem (oracle forms 10g)

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

Client_ole2 problem [message #458280]

Fri, 28 May 2010 07:25

shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune

Senior Member

Hello
I want to export forms data into Excel sheet
for that i am using Client_Ole2.
I have attached Webutil object library and Pl/Sql library
Still I can not export data from Form to Excel sheet
Please help me out

Report message to a moderator

Re: Client_ole2 problem [message #458281 is a reply to message #458280]

Fri, 28 May 2010 07:33

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

You've given no details of what code you are actually using.
You have given no details of what is (if anything) currently happening. Is excel opening for example?

And you expect us to help?

More details needed.

Report message to a moderator

Re: Client_ole2 problem [message #458321 is a reply to message #458281]

Fri, 28 May 2010 10:51

shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune

Senior Member

if I use ole2 instead of client_ole2 then it is run properly on local machine.
But as per web application , i want to use Client_ole2.
Is there any setting needed to run Client_ole2 object?

args := CLIENT_OLE2.CREATE_ARGLIST;
CLIENT_OLE2.ADD_ARG(args, 'c:\example.xls');
CLIENT_OLE2.INVOKE(doc, 'SaveAs', args);
CLIENT_OLE2.DESTROY_ARGLIST(args);

Report message to a moderator