tag:blogger.com,1999:blog-5685561046226514617.post651144621076173756..comments2023-12-20T04:11:51.446-08:00Comments on Exploration Through Example: PL/SQL (Forms) Word and Excel manipulation using OLE (OLE2)Jan Križanhttp://www.blogger.com/profile/09923737115400827604noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5685561046226514617.post-72550299079272122132023-07-24T03:24:16.066-07:002023-07-24T03:24:16.066-07:00Hello. Can u help with a function to insert image ...Hello. Can u help with a function to insert image in excel file using ole2 functions in oracle formsswetsurhttps://www.blogger.com/profile/14617655053876731131noreply@blogger.comtag:blogger.com,1999:blog-5685561046226514617.post-25566719308041534152014-12-31T18:22:43.049-08:002014-12-31T18:22:43.049-08:00i want to open the word document using webutil cli...i want to open the word document using webutil clien_ole2 but it give the error oracle.form.ole.olefunction not found.webutil is configured becuase all the tab of Demo form come with webutil folder is working except the ole tab.what is error and h i correct it.?Anonymoushttps://www.blogger.com/profile/10370494867017077781noreply@blogger.comtag:blogger.com,1999:blog-5685561046226514617.post-89759335199505520812014-12-31T18:14:48.375-08:002014-12-31T18:14:48.375-08:00plz reply to meplz reply to meAnonymoushttps://www.blogger.com/profile/10370494867017077781noreply@blogger.comtag:blogger.com,1999:blog-5685561046226514617.post-56575076814484688942011-11-09T02:22:52.541-08:002011-11-09T02:22:52.541-08:00I am a newbie please help me how i can use word pa...I am a newbie please help me how i can use word package(already created) to change the orientation and run macros in a msword..give code snaps <br />Thanks in advance..Mukesh Kumarhttps://www.blogger.com/profile/08228849215369093999noreply@blogger.comtag:blogger.com,1999:blog-5685561046226514617.post-3169896650896490702011-04-18T00:59:30.257-07:002011-04-18T00:59:30.257-07:00Hello.
You said that you can see how Word .dot fi...Hello.<br /><br />You said that you can see how Word .dot file is filled with data?<br /><br />If that is the case, we need to try to find error in save procedure... I didn't go too much deep into your code, is everything initialized properly?Jan Križanhttps://www.blogger.com/profile/09923737115400827604noreply@blogger.comtag:blogger.com,1999:blog-5685561046226514617.post-72042421643688504752011-04-15T01:34:04.927-07:002011-04-15T01:34:04.927-07:00do you work with a word template .dot?
I have a p...do you work with a word template .dot?<br /><br />I have a problem Problem with a template word and client_ole2 in the folowing code:<br /><br />I have the folowing global variables in the specification package<br />App CLIENT_OLE2.OBJ_TYPE;<br />Docs CLIENT_OLE2.OBJ_TYPE;<br />Doc CLIENT_OLE2.OBJ_TYPE;<br />Selection CLIENT_OLE2.OBJ_TYPE;<br /><br />And i have two functions in the body package:<br /><br />---- This function takes a template word located at<br />---- NomFich = C:\DOCUME~1\MADX92\CONFIG~1\Temp\MADQ80_CIA.dot<br />FUNCTION F_NuevWord (a_NomFich VARCHAR2) RETURN BOOLEAN IS<br />v_Lista CLIENT_OLE2.LIST_TYPE;<br />v_ObjEx CLIENT_OLE2.OBJ_TYPE;<br />v_Err_Code BINARY_INTEGER;<br />v_Err_Text VARCHAR2(255);<br />BEGIN<br />App := CLIENT_OLE2.CREATE_OBJ ('Word.Application');<br />CLIENT_OLE2.SET_PROPERTY (App, 'Visible', 0);<br />Docs := CLIENT_OLE2.GET_OBJ_PROPERTY (App, 'Documents');<br />v_Lista := CLIENT_OLE2.CREATE_ARGLIST;<br />CLIENT_OLE2.ADD_ARG (v_Lista, a_NomFich);<br />v_ObjEx := CLIENT_OLE2.INVOKE_OBJ (Docs, 'Add', v_Lista);<br />CLIENT_OLE2.DESTROY_ARGLIST (v_Lista);<br />CLIENT_OLE2.RELEASE_OBJ (v_ObjEx);<br />RETURN TRUE;<br />EXCEPTION<br />WHEN CLIENT_OLE2.OLE_ERROR THEN<br />--shows the error<br />RETURN FALSE;<br />WHEN OTHERS THEN<br />P_INFO('Error: SVAGEST01:PCK_WORDDOC.F_NuevWord');<br />RETURN FALSE;<br />END F_NuevWord;<br /><br /><br />---This function saves the word document filled with data using ---the template word by a function WriteText<br />---a_NomFich = \\ESMADFFS01\PRUEBAS\SVAPRU\WORDDOCS\2011_04---\248070.doc<br />FUNCTION F_SaveAsWord (a_NomFich VARCHAR2) RETURN BOOLEAN IS<br />v_Lista CLIENT_OLE2.LIST_TYPE;<br />v_ObjEx CLIENT_OLE2.OBJ_TYPE;<br />ActDoc CLIENT_OLE2.OBJ_TYPE;<br />v_Err_Code BINARY_INTEGER;<br />V_Err_Text VARCHAR2(255);<br />BEGIN<br />v_WdActDoc := CLIENT_OLE2.GET_OBJ_PROPERTY (App, 'ActiveDocument');<br />v_Lista := CLIENT_OLE2.CREATE_ARGLIST;<br />CLIENT_OLE2.ADD_ARG (v_Lista, a_NomFich);<br />CLIENT_OLE2.ADD_ARG (v_Lista, 0);<br />v_ObjEx := CLIENT_OLE2.INVOKE_OBJ (v_WdActDoc, 'SaveAs', v_Lista);<br />CLIENT_OLE2.DESTROY_ARGLIST (v_Lista);<br />CLIENT_OLE2.RELEASE_OBJ (v_WdActDoc);<br /><br />RETURN TRUE;<br />EXCEPTION<br />WHEN CLIENT_OLE2.OLE_ERROR THEN<br />---SHOWS THE ERROR<br />RETURN FALSE;<br />WHEN OTHERS THEN<br />P_INFO('Error en SVAGEST01:PCK_WORDDOC.F_SaveAsWord');<br />RETURN TRUE;<br />END F_SaveAsWord;<br /><br /><br />I got a error at<br />v_ObjEx := CLIENT_OLE2.INVOKE_OBJ (v_WdActDoc, 'SaveAs', v_Lista);<br /><br />WUO-714:Unable to get the last OLE Error details; Exception null.<br />WUO-705:Unable to invoke Method: SaveAs; Exception com.jacob.com.ComFailException: VariantChangeType failed<br /><br />The word document was created correctly by the template but i cant´t save the document generated name_file.doc. I don´t know what is the problem.<br /><br />can you help me please?El blog de Andréshttps://www.blogger.com/profile/09743236745637124121noreply@blogger.com