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: Surges Bay TAS 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: Surges Bay TAS 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: Fri Jul 21 23:56:47 CDT 2017

Total time taken to generate the page: 0.10953 seconds