Re: ORA - 305500 Unhandled Exception when making an OLE2 call - HELP!

Vaguely remember a similar problem from years back.

Try using OLE2.GET_OBJ_PROPERTY instead of Invoke_Obj, there are a few known issues surrounding the use of invoke_obj. Also, are the word documents write protected? Try searching MetaLink at www.oracle.com (under Support) for more explainations

Mark

anthony_davies_at_hotmail.com (Anthony Davies) wrote in message news:<52d165fb.0111120920.79f5053b_at_posting.google.com>...
> We are currently running Oracle 6i on Metaframe 1.8 for Windows 2000
> have have a problem with the code below:
>
> When our application tries to make and OLE call to MS Word 97 we get
> an ORA-305500 when the OLE2.INVOKE_OBJ is executed.
>
> However, I have noticed that if we give the User Power User or
> Administrator rights the code works fine. I have also noticed that
> with standard user rights when the OLE call is made Word does not open
> bu I can see Winword.exe in the processes...
>
> Has anybody come across this before as your help would be greatly
> appreciated.
> It must be a permissions problem Registry/File??? but I cannot locate.
> I have tried using FileMon/RegMon but with no luck.
>
> Thanks in advance.
>
> p_error := null;
> l_alert.display_message('WARN', 'path and file
> '||p_path_and_file);
> v_app_id := OLE2.CREATE_OBJ('Word.Application');
> l_alert.display_message('WARN', 'assign v_docs_id next');
> v_docs_id := OLE2.GET_OBJ_PROPERTY(v_app_id, 'Documents');
> l_alert.display_message('WARN', 'assign v_arg_list next ');
> v_arg_list := OLE2.CREATE_ARGLIST;
> l_alert.display_message('WARN', 'ole2 add_arg next');
> OLE2.ADD_ARG(v_arg_list, p_path_and_file);
> l_alert.display_message('WARN', 'assign v_doc_id next');
> v_doc_id := OLE2.INVOKE_OBJ(v_docs_id, 'Open', v_arg_list);
> l_alert.display_message('WARN', 'ole2 destroy_arglist next');
> OLE2.DESTROY_ARGLIST(v_arg_list);
Received on Tue Nov 13 2001 - 10:32:55 CET