I have This Code working on the local form builder after starting the oc4j and run the form. but using OLE2.
but when using the Cleint_ole2 on the application to invoke an object on the client machine.
but nothing happend, while i have tested the webutil configaration and its working fine.
i use this code to print any word document without openning it. and here is the code in when_button_pressed
DECLARE application CLIENT_OLE2.OBJ_TYPE;-- Declare a object OLE args CLIENT_OLE2.LIST_TYPE; -- Declare List of Parameters to obj. OLE begin application := CLIENT_OLE2.CREATE_OBJ('WORD.Basic'); -- Start a process WordBasic args:= CLIENT_OLE2.CREATE_ARGLIST;-- Create a list of Parameters -- Add param. file_name with path(x. c: empmy.doc) :blk01 is my block
I need to generate quotation from Forms 6i. A copy fo the quotation is being uploaded. All information in the word document that are highlighted in yellow are taken from a database.
I need to create the document in the format of the uploaded file. There will be some tables also in the document.
Basically I have requirement to generate a Word doc (letter to a Word mail merge) from a button/navigation link pressed on Apex page which will gather data from the report and fill in values in appropriate place in Word doc.
Is this even possible with Apex with/o BI Publisher
I have Fop installed and tested , PDF works great but excel and RTF is not reading the encoding on attachment download.I am aware of new PDF feature in 4.2.2 but upgrade is just not the scope right now.
I want to export forms data into Excel sheetfor that i am using Client_Ole2.I have attached Webutil object library and Pl/Sql libraryStill I can not export data from Form to Excel sheet
how can i enable user to select and save any document into oracle database and later on choose to retrieve and display it.it should be like windows file open save.
I need some one provide me with doc, pdf, ppt, notepad anything to understand how to use OLE2
I know you will say search in this forum or google it i already search it and google it but all of them are examples or a questions for specific requirement. No one explain how is this code work even oracle it self check this link
[URL].......
no explanation . i don't want that's much
at least like this
DECLARE app OLE2.OBJ_TYPE; this for . . . . . . docs OLE2.OBJ_TYPE; this for . . . . . . doc OLE2.OBJ_TYPE; this for . . . . . . selection OLE2.OBJ_TYPE; this for . . . . . . args OLE2.LIST_TYPE; BEGIN
I am using OLE2 to update an excel spreadsheet from Oracle Forms 6i. If the excel spreadsheet is already open, the code runs through fine, and even asks if you want to replace the file when running the lines: OLE2.INVOKE(worksheet, 'Save');
OLE2.INVOKE(workbook, 'Save');
However, the file never gets updated. There is no error that appears. I would like to have the program check if the file is open before running the program;
Im trying to display a word file from a blob column of table in reports 11g . In reports 6i OLE2 file format was available for that, but in 11g it became obsolete.
I just trying to import some informations from excel to Oracle using OLE2 over Oracle Forms 6i, but It´s very slow when I have import under then 10k lines. anything to optimize that ? Follow the code used...
When I click on excel report button on the parameter form, the excel runs behind the form instead of in running in fron of it thereby making it partially invinsible. I am having to minimise the form to have a clear view. This is not the case with Forms 10g. Is there an extra code on the OLE2 to send the form to the background so that the excel output can take over the screen.
I have u na forms developer application in 6.0 that generates a Word document. This application runs successfully on Windows XP operating system. We now have PC's new operating system Windows 7 and officce 2010. My procedure reads a specific route where a template in Word which is used to generate the document. In the user's PC application that does not generate the document even shows me an error message. But when I enter my network user with the user's PC and the document genre generates me perfectly. I checked if the user has access to the server path specifies where the template encuntra wish to open and if you have them.
I need to create a doc file using Microsoft Word where I can get data from an Oracle DB.
I search on MS Word, for something like ODBC (like in Excel and Access) but in vain.
I need to do this so I can format the data on the doc file in any way I want. Not like in Oracle Reports, where formatting is a little bit restrictive.
am trying to use secure call to reports from forms using the frmrwinteg.jar javabean.
when i set the implementation class of the javabean area i still have the error FRM-13008 can't find javabean with name..,but i ignore it as i read at the whitepaper downloaded from OTN. and follow all instructions add to java directory,, add to formsweb,, add parameter to basejini.htm
each time i call the report i have been asked to connect and when i run the form my username and password are written to the consol and i still can see them at the html code when call parameter form, my code is
DECLARE
rep_url varchar2(2000);
BEGIN rep_url:='http://office_server:8889/reports/rwservlet?server=repserver10&report=d:mm-J.JSP &desformat=htmlcss&destype=CACHE¶mform=yes&userid='; set_custom_property('block3.userid_bean',1,'WRITE_LOGOUTPUT','true');
[code]...
and this is what is written to the consol
FrmReportsInteg1: Debugging true FrmReportsInteg1: Adding new userid string "xx/xx@xxxxx" FrmReportsInteg1: ADD_REPORTS_CONNECT: xx/xx@xxxxx FrmReportsInteg1: Setting cookie path to /reports/TEST/
[code]/....
i DON'T KNOW WHERE IS THE ERROR THAT MAKE THIS NOT WORK.
My client system is WinXP.I want to store a Word/Excel document to Oracle Blob column and choosed the command named "piecewise.exe",it seems a free tool on the web, to store the document to oracle,but occausionally failed.So I need alternative which is stable and available.
I have made one application form where users need to enter some data. This data is getting inserted in four tables. As in for now the data is properly getting saved and retrieved only for one user at a time. But problem arrives when more than one users are simultaneously making an entry and saving the data at one time.Same number is getting generated for the users who are saving the data at one time which should not happen.
I am using oracle developer suit(form 10g), Using OLE2 object to initialize excel, On "BEFORE REPORT TRIGGER" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error :
i have a datablock with a list item and display item.and after selecting the list item (registration number),corresponding data gets filled into the display item.but when I click the save button(ok) data doesn't go into the database,
I currently have a field in which the user inputs a number, but before this number is allowed to be saved to the database it has to be checked to see if the number is already stored in a different field within the database. For example, if the number is not in the database the user cannot put that number into the field.
I do want it to be user input so I don't want a LOV linked to the appropriate field in the database.
Is below anyway close to the way it should be done? For some reason seq_rec.seq seems to give me 3 and doesn't seem to compare it with each of the values in the database.
DECLARE cursor seq_curs IS SELECT SEQ FROM ZZJOB; seq_rec seq_curs%rowtype; none_existing_seq EXCEPTION; invalid_seq EXCEPTION; return_alert NUMBER;
[code]....
Just say the field in my database has numbers: 1 2 3 4 and 5 in the field that i allow the user to input data they can only enter 1 2 3 4 or 5. Hence the check needs to be made with te database field to check if the input number is already in the database.
P.S. they are separate fields for different things, the numbers just need to be in one field before they can be added in the other.
on clicking select.show,while running the form data(DATE and APPLICANT_NO) is being accesed from local database but after uploading the form the data is not coming from main database,even if the data is present in the main database.
