Home » Developer & Programmer » Forms » Help me please with WEBUTIL_CLIENT_OLE2 (Oracle frm builder 10g, WEBUTIL 10.1.2.2, WindowsXP sp2)
icon9.gif  Help me please with WEBUTIL_CLIENT_OLE2 [message #277879] Thu, 01 November 2007 01:09 Go to next message
VladimirEE
Messages: 3
Registered: October 2007
Location: Russia
Junior Member
I am sorry for my English Embarassed , I hope you will understand.
I use the package "Client_OLE2" for access to the objects, their methods and properties on the CLIENT side (Concretely I utillize COM library: CAPICOM.dll).

Problem:
I can not initialize property of object, by other object already initialized before (types are proper).

Just for example (java code and analogue PL/SQL code):
1)Get_Property():
--java/c code:
 the_obj=spreadsheet_obj.Application
--PL/SQL code:
the_obj:=Get_Obj_Property(spreadsheet_obj, 'Application');

2) Set_Property():
--java/c code:
cell.Value="Hello Excel!"
--PL/SQL code:
Set_Property(cell, 'Value', 'Hello Excel!');

3)Invoke():
--java/c code:
v_book=v_books.Open("C:\1.xls")
--PL/SQL code:
ADD_ARG(v_arglist, 'C:\1.xls');
v_book := INVOKE_OBJ(v_book, 'Open', v_argList);

It's works.
I can not write this line in PL/SQL:
--java/c code:
Signer.Certificate = Certificates.Item(1);
--PL/SQL code:
??????????????????????

Logically to use the Next:
   DECLARE
   test Client_OLE2.obj_type;
   ...
   BEGIN
   ...
   --it's works
   v_arglist := Client_OLE2.Create_Arglist; 
   Client_OLE2.Add_Arg(v_argList, 1); 
   test:=Client_OLE2.Invoke_Obj(Certificates,'Item', v_argList);
   Client_OLE2.DESTROY_ARGLIST(v_argList);
   --it's does not work
   Client_OLE2.Set_Property(Signer, 'Certificate', test);
   ...
   END;

But it does not work: "Type of the last arguments mismatch".

How can I write the line
Signer.Certificate = Certificates.Item(1)
in PL/SQL code?
Thanks.
Re: Help me please with WEBUTIL_CLIENT_OLE2 [message #279507 is a reply to message #277879] Thu, 08 November 2007 19:04 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem? Search this forum for 'client_ole' or 'excel ole'.

David
Re: Help me please with WEBUTIL_CLIENT_OLE2 [message #279736 is a reply to message #279507] Fri, 09 November 2007 21:42 Go to previous messageGo to next message
VladimirEE
Messages: 3
Registered: October 2007
Location: Russia
Junior Member
Thanks for reply. I've refused to using OLE. Now I use WEBUTIL_C_API.
Re: Help me please with WEBUTIL_CLIENT_OLE2 [message #280523 is a reply to message #279736] Wed, 14 November 2007 00:03 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
We'd be very happy for you to post some of your code against this thread when you get it working.

David
Previous Topic: Horizontal Toolbar position
Next Topic: reading multiple excel file using WEBUTIL functions
Goto Forum:
  


Current Time: Mon Dec 05 15:06:50 CST 2016

Total time taken to generate the page: 0.19417 seconds