Home » Developer & Programmer » Forms » CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 (Developer Suite 10G ,Forms Version 10.1.2.0.2 )
CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 [message #564593] Sun, 26 August 2012 06:51 Go to next message
deepakmannazhi
Messages: 113
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear All,
How are you ?
We are using Quote:
CLIENT_OLE2
for invoking Outlook application from Forms.

It is working properly in Quote:
Forms Version 9.0.4.0.19
.

But it is not working In Quote:
Forms Version 10.1.2.0.2
.There is an error in java console,while executing Quote:
client_ole2.create_obj ('Outlook.Application')


Quote:
java.lang.ExceptionInInitializerError: java.security.AccessControlException: access denied (java.lang.RuntimePermission loadLibrary.jacob)



All other webutil functions are working properly.

Can anyone guide me

[Updated on: Sun, 26 August 2012 06:54]

Report message to a moderator

Re: CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 [message #564629 is a reply to message #564593] Mon, 27 August 2012 02:41 Go to previous messageGo to next message
deepakmannazhi
Messages: 113
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear All,

here is the code
PROCEDURE send_mail (p_file VARCHAR2)
IS
   v_temp       VARCHAR2 (1000);
   objoutlook   client_ole2.obj_type;
   objmail      client_ole2.obj_type;
   objarg       client_ole2.list_type;
   objattach    client_ole2.obj_type;
   objattach1   client_ole2.obj_type;
   args         ole2.list_type;
BEGIN
   objoutlook := client_ole2.create_obj ('Outlook.Application');
   objarg := client_ole2.create_arglist;
   client_ole2.add_arg (objarg, 0);
   objmail := client_ole2.invoke_obj (objoutlook, 'CreateItem', objarg);
   client_ole2.destroy_arglist (objarg);
   objattach := client_ole2.get_obj_property (objmail, 'Attachments');
   objarg := client_ole2.create_arglist;
   client_ole2.add_arg (objarg, p_file);
   client_ole2.invoke (objattach, 'Add', objarg);
   client_ole2.set_property (objmail, 'To', ' ');
   client_ole2.invoke (objmail, 'Display');
   --    client_ole2.invoke (objmail, 'Send');
   client_ole2.RELEASE_OBJ (objattach);
   client_ole2.RELEASE_OBJ (objmail);
   client_ole2.RELEASE_OBJ (objoutlook);
   client_ole2.destroy_arglist (objarg);
EXCEPTION
   WHEN OTHERS
   THEN
      MESSAGE (SQLCODE);
      MESSAGE (SQLERRM);
END send_mail;
Re: CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 [message #564631 is a reply to message #564629] Mon, 27 August 2012 03:38 Go to previous messageGo to next message
deepakmannazhi
Messages: 113
Registered: February 2010
Location: Dubai, UAE
Senior Member

hi is there any confusion in this post?
Re: CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 [message #564976 is a reply to message #564631] Wed, 29 August 2012 14:41 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Probably not, but it seems that noone (who read your question) knows the answer. Me included.
Re: CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 [message #565066 is a reply to message #564976] Thu, 30 August 2012 05:21 Go to previous messageGo to next message
deepakmannazhi
Messages: 113
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear Littlefoot ,
Can we invoke outlook from Oracle Forms, through any other methods?
Re: CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 [message #565086 is a reply to message #565066] Thu, 30 August 2012 08:04 Go to previous messageGo to next message
joy_division
Messages: 4453
Registered: February 2005
Location: East Coast USA
Senior Member
What about CLIENT_HOST?
Re: CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 [message #565113 is a reply to message #564593] Thu, 30 August 2012 12:08 Go to previous messageGo to next message
Kaeluan
Messages: 178
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Hi,
I just test your code on my App Server 10.1.2.3 and it's working perfectly.
Your problem seem to be related to the jacob library that is required to invoke client application.
Are you sure you have privilege on the folder where the jacob is downloaded from the app server (ex: C:\Program Files\Java\jre6\bin)?
Re: CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 [message #565237 is a reply to message #565113] Sat, 01 September 2012 02:35 Go to previous messageGo to next message
deepakmannazhi
Messages: 113
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear Joy,
Thanks for your suggestion, let me try that way.

Dear Kaeluan,

Thanks.
We are not using application server. We are using simple IDS configuration.

All other web util functions are working properly. File Transfer,Excel creation, etc.


Re: CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 [message #565248 is a reply to message #564593] Sat, 01 September 2012 07:43 Go to previous message
deepakmannazhi
Messages: 113
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear Kaeluan,

Cheers It is working fine now Smile

I have re downloaded and copied the jacob.jar in FORMS/JAVA directory. And it is signed.
Copied jacob.dll in FORMS\WEBUTIL directory.


Thanks a lot to you all.. Smile

Deepak


Previous Topic: CLIENT_OLE2.CREATE_OBJ('Excel.Application') not working
Next Topic: Procedure Execution Taking Too Long
Goto Forum:
  


Current Time: Thu Apr 17 09:36:27 CDT 2014

Total time taken to generate the page: 0.14560 seconds