Forms :: Printing A Word Document

Feb 9, 2011

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

[Code]...

View 1 Replies


ADVERTISEMENT

Forms :: Open New Word Document And Delete It?

Mar 26, 2013

i have one word doc file name is sample.doc

i have 3 buttons in my canvas. 1st button is to open a word document.

codings:

declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('D:Program FilesMicrosoft OfficeOffice12winword.exe F:DevSuiteHome_1formssamples.doc',DDE.APP_MODE_NORMAL);
end;

2nd button:

i want to delete the existing sample.doc file via forms

i dont know the codings.

View 2 Replies View Related

Forms :: Create And Format A Word Document From 6i

Oct 6, 2011

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.

View 1 Replies View Related

Forms :: Open Word Document / Excel / PDF From Oracle?

Mar 25, 2008

I would like to open a word document /excel sheet /pdf from oracle forms.

View 20 Replies View Related

Forms :: Open Word Document / Excel And PDF From Oracle?

Apr 29, 2010

does the path of office on the server or on the client PC?

View 1 Replies View Related

Forms :: Ole2 Data From Database To Word Document?

Apr 25, 2007

I am porting data from database to word document.Initially i am creating the table using the following

hSelection := OLE2.GET_OBJ_PROPERTY(hApplication, 'Selection');
hTables := OLE2.GET_OBJ_PROPERTY(hDocument , 'Tables' );
hRange := OLE2.GET_OBJ_PROPERTY(hSelection, 'Range');
args := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG_OBJ(args, hRange); --Range
OLE2.ADD_ARG(args, 26); --NumRows
OLE2.ADD_ARG(args, 4); --NumColumns
OLE2.ADD_ARG(args, wdWord9TableBehavior); --DefaultTableBehavior
OLE2.ADD_ARG(args, wdAutoFitContent); --AutoFitBehavior
hTable := OLE2.INVOKE_OBJ(hTables, 'Add', args);

But i want to change the columnwidth. As you see above i have 4 columns, in that first column should be double than other column.

peice of code to change th ewidth of column in word document.

View 6 Replies View Related

Forms :: Open Document Present In Shared Drive In Microsoft Word?

Feb 23, 2011

I want to open a word document which is present in a shared drive in Microsoft word from my oracle 10g form.

View 2 Replies View Related

Forms :: How To Set MS Word Document Header And Footer Using Forms 6i

Dec 10, 2010

Now I want to use an existing MS Word file from file system (e.g d: est est1.doc) and add header & footer (e.g docname Page x of x) using Forms 6i.

View 3 Replies View Related

Application Express :: Word Document / Mail Merge With Values From Reports

May 7, 2013

Using apex 4.1.1 , linux , 11gr2

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.

View 0 Replies View Related

Forms :: Barcode Label Printing - Prevent Label From Printing N/V For Null Values?

Jul 8, 2013

I have set up a label which interacts with our LIMS system. I have set up variables on this label which pull in attribute values from the available tokens. When the attribute value is null, the label is automatically inserting 'N/V' onto the label.

I would prefer for the variable to appear as a blank field on the label when the attribute value is null in the LIMS. can't find anything in the user's manual. Perhaps there is some setting where you can define what to display for null values. I can't seem to find any information on this.

View 1 Replies View Related

Forms :: Open Application Word 2010 With Forms Developer 6.0 - Windows 7?

Apr 20, 2011

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.

View 1 Replies View Related

Forms :: Secure Web.show-document() - Getting Error?

May 20, 2010

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.

View 1 Replies View Related

Forms :: Enable User To Select And Save Any Document Into Database?

Dec 6, 2012

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.

View 2 Replies View Related

Forms :: Barcode Generation And Printing

Dec 14, 2011

We need to generate barcode through oracle forms and print the barcode using Zebra Printer.

How to generate the barcode using oracle forms and which software we should use to generate the barcode as well as how can we print the barcode label with customize information on label with barcode.

View -1 Replies View Related

Forms :: Printing Reports Directly?

Jan 31, 2011

I'm developing now in 11g and i have some reports that i want to send directly to the printer. I been having some troubles and as i searched the web, i saw that for 9i and 10g, this was not possible without using orarrp. But i can't find any info about this for 11g. Is this true that i can only let user print direct using this tool? Plus, is this tool available for linux x64? Can i add the printer to the server and would it work now?

View 2 Replies View Related

Forms :: 10g Screen Not Printing Through Citrix?

Mar 24, 2010

We access the 10g forms and reports application through citrix and non citrix environments, when we are trying to print the screen from citrix environment the screens are getting shaded but if we print through non citrix environment screens are printing fine.

View 2 Replies View Related

Forms :: Printing Double-Sided Using SET_REPORT_OBJECT_PROPERTY?

Jun 9, 2010

I support old oracle code and we currently print using the set report object property.

I recently was requested to modify all of our printing to two-sided printing from the current one page per sheet.

I am trying to figure out if there is a parameter I can set, i.e.REPORT_OTHER or something else that would allow me to do this.

View 4 Replies View Related

Forms :: How To Store Word / Excel Documents To BLOB Column

Mar 29, 2011

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.

View 1 Replies View Related

Forms :: Create A Form To Store Any Excel / Word Files?

Jul 1, 2011

i m using oracle 10g forms.

i want to create a form where i can store any excel / word etc files.

View 6 Replies View Related

Forms :: Generate Unique Document Numbers When More Than One User Inserting In Form At One Time

Dec 5, 2011

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.

View 4 Replies View Related

Forms :: Direct Printing On 10g - Errors When Distribute Output

Jul 20, 2012

I have a problem with direct printing on forms 10g, I try to explain all schema...Firstly, this is my code

repid := find_report_object('OPERATOR_BARKOD');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,RUNTIME);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rep_server_oracle');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,PRINTER);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESNAME,'ipp://192.168.200.22/operatorbarcode');
v_rep := RUN_REPORT_OBJECT(repid);

The code works fine if i change the "report_desttype" to FILE or CACHE and give a local path "REPORT_DESNAME" like "/home/ oracle/ desktop/ barcode.pdf"

Secondly, My oracle application server is running on oracle linux 5.0

Thirdly, I defined network printer(model:XeroxPhaser3435) over ipp which path is "ipp://192.168.200.22" and name is "P3435" also default printer for oracle user and printer works i can get test page.

I wonder is printer path correct?("ipp://192.168.200.22/operatorbarcode"). I think the problem occurs in this step also is there any extra settings for oracle application server to use network printer...When I look at the reports server jobs it give an error "Executed successfully but there were some errors when distribute the output".

View 2 Replies View Related

Forms :: 11g OLE2 Excel Printing Behind Parameter Form

Apr 4, 2012

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.

View 6 Replies View Related

Forms :: Record To Be Inserted Into Table As Audit-trail Of Printing

Feb 3, 2010

I am using oracle developer 10g. I want to know the status of the printer where i want to print. If the running report is printing or in queue then a record is to be inserted into a table as audit-trail of printing. Idon't want to do it manually.

View 1 Replies View Related

Forms :: MS Word Rich Text Format In Text Item

Apr 17, 2012

Can I use rich text item on oracle form10G with some simple features like BOLD, UNDERLINE, ITALIC and if possible one more feature like spell check.

I Google my requirement, but mostly I found win word attachment. Further more if I can save this type of data in field then how can I print in report.

View 3 Replies View Related

Load Document / Image As Blob?

Feb 24, 2007

I have a table with a blob type field. We need to read scanned documents (doc, pdf, tif, jpg, etc.) from a specified directory and insert relevant data into a table, including the document as a blob.

View 3 Replies View Related

SQL & PL/SQL :: How To Install Excel Document Type

Feb 15, 2013

We are trying to develop one excel sheet from PL/SQL. But the requirement is that we want specific colors and fonts for specific rows and columns. For that purpose, we are using Excel Document Type. But we are getting error that Excel Document Type should be declared.How can we get rid of this error?

View 2 Replies View Related

Text :: How To Get Number Of Occurrences Per Document

Nov 8, 2013

I have a table of documents (excel, word, pdf, txt) stored in blob column. I want that SCORE returns the number of occurrences within each document, so I'm using this piece of code: 

SELECT bdt.*, SCORE(1) AS score_1, DBMS_CRYPTO.HASH(archivo, 3) AS cod_hashFROM crg_ctx_archivos_recibidos bdt

WHERE CONTAINS(archivo,'<query>   <textquery lang="SPANISH" grammar="CONTEXT">DEFINESCORE(paz, OCCURRENCE * 0.1)</textquery>    <score datatype="INTEGER" algorithm="COUNT"/></query>', 1) > 0

ORDER BY SCORE (1) DESC; 

However I'm getting a maximum score of 10, but I know one of these documents have 490 matches. How can i get the exact number of matches per document? I'm using Oracle 11.2

View 3 Replies View Related

SQL & PL/SQL :: How To Get First Word From String

Aug 22, 2013

how to get first word from string.example i have string like:-

Jack Bore American
Mark D'suz Australian
Raj
Deniel indian
Some

i am expecting first word as out put like :-

jack
mark
Raj
Deniel
Some

in the same maner if i want should get two words also.

View 36 Replies View Related

Printing ZPL From DOS?

Sep 16, 2010

I am currently printing from a DOS window to a Zebra printer as follows:

-Start, Run
-ftp to the print server
-enter userid and password
-type in put <filename>.zpl

However, at the supplier site, I am being asked for a simple print command that would send the .zpl file to th printer that would print the label (Open a file, click on print).

Here are the printer details that I am using:

Model: Zebra170XiII
Host: sfezebra
Version: V18.7.1
Serial Number: 716314

View 4 Replies View Related

JDeveloper, Java & XML :: Procedure To Query A XML Document?

Apr 13, 2012

I am using an oracle 11g database. I have an XML document named test_table.xml stored in table TEST_CLOB, Ex: TEST_CLOB(ID NUMBER, XML_DOC CLOB)

Here are the contents of test_table.xml file.

<xml version = "1.0"" ?>
<! DOCTYPE main [
<! Element main (DATA_RECORD*) >
<! COLUMN1?, COLUMN2?, COLUMN3, COLUMN4?, COLUMN5, COLUMN6?, GEOM?) +>
<! ELEEMENT COLUMN1 (#PCDATA)>
<! ELEEMENT COLUMN2 (#PCDATA)>

[code]....

I need a database procedure where I will pass in COLUMN1, COLUMN2 AND COLUMN3 values and it should return all the columns from the xml document. ie. ex: below is what I would like to query

select column1, column2, column3 column4 column5, column 6
from the TEST_TABLE.XML ---- XML DOCUMENT FILE NAME
WHERE column1 = 'ARENAS'
AND column2 = 'NBA'
AND column 3 = 'UNITED CENTER';

View 21 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved