OraFAQ Forum: Forms » CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2

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 )

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

CLIENT_OLE2 NOT WORKING IN Forms Version 10.1.2.0.2 [message #564593]

Sun, 26 August 2012 06:51

deepakmannazhi
Messages: 137
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

deepakmannazhi
Messages: 137
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;

Report message to a moderator

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

deepakmannazhi
Messages: 137
Registered: February 2010
Location: Dubai, UAE

Senior Member

hi is there any confusion in this post?

Report message to a moderator

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

Littlefoot
Messages: 21813
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.

Report message to a moderator

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

deepakmannazhi
Messages: 137
Registered: February 2010
Location: Dubai, UAE

Senior Member

Dear Littlefoot ,
Can we invoke outlook from Oracle Forms, through any other methods?

Report message to a moderator

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

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

What about CLIENT_HOST?

Report message to a moderator

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

Kaeluan
Messages: 179
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)?

Report message to a moderator

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

deepakmannazhi
Messages: 137
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.

Report message to a moderator

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

deepakmannazhi
Messages: 137
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 11:11:02 CDT 2024