OraFAQ Forum: Unix » Printing to PDF in older versions of oracle

Home » Infrastructure » Unix » Printing to PDF in older versions of oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Printing to PDF in older versions of oracle [message #98501]

Sun, 05 December 2004 11:12

Ethan
Messages: 11
Registered: December 2004

Junior Member

does anyone know to to setup a pdf writer in oracle 10.7?� We have one computer guy(not a dba) and he is under the impression that to add a printer in our version or oracle, it must have an IP address, which the pdf writer doesn't(the comp that has the software does, but if you give orace that ip address, what will casue the pdf writer to run?

My main goal is to pdf reports and orders, that have special tmepelts, so exporting is not an option

�

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98503 is a reply to message #98501]

Mon, 06 December 2004 09:18

andrew again
Messages: 2577
Registered: March 2000

Senior Member

There are several Windows based tools where you put a file into an IN directory, it gets converted to PDF in an OUT directory. If your Oracle is on Unix, then you can write your output file into an NFS mounted directory. The windows IN directory maps to this location. The problem seems to be that when you they to pring a non-standard size which goes out of bounds, then the Windows machine gets a confirmation dialog box (from the PDF print driver) which hangs the whole queue until it's acknowledged by a user...

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98504 is a reply to message #98503]

Mon, 06 December 2004 09:25

andrew again
Messages: 2577
Registered: March 2000

Senior Member

I probably mis-understood - you are already creating the pdf right? You specify acrobat as the output fmt in the reports runtime...

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98537 is a reply to message #98504]

Wed, 22 December 2004 04:31

Ethan
Messages: 11
Registered: December 2004

Junior Member

hmmm...You did misunderstnad, but i am not already creating the PDF....I would like to create a pdf from oracel 10.7 Right now, from oracle, we can only print to a real physical printer that has an IP address. Our It guy does not know how to setup a PDFwriter in oracle, so that we can print straight to PDF from oracle......

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98538 is a reply to message #98537]

Wed, 22 December 2004 08:54

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Well, I know that Oracle reports does support it. The command line is something like:
rwrun60 report=path/report.rdf userid=scott/tiger@db P_trader='value' destype=file desformat=pdf desname=path/filename.pdf batch=yes

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98539 is a reply to message #98538]

Wed, 22 December 2004 11:17

Ethan
Messages: 11
Registered: December 2004

Junior Member

BTW, i am told we are using oracle reports version 6, and that it does not suport printing to PDF(only what i'm told)

Thanx

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98540 is a reply to message #98538]

Wed, 22 December 2004 11:18

Ethan
Messages: 11
Registered: December 2004

Junior Member

I showed your reply to my IT guy, and he said that means nothing to him...he's not a "unix guy"(your reply went over his head), so would it be possible for you to give detailed intrusctions on how to setup a pdf writer as a rpinter?

Thanx so much for your help

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98541 is a reply to message #98540]

Wed, 22 December 2004 12:28

andrew again
Messages: 2577
Registered: March 2000

Senior Member

I put together a quick little "hello world" some time ago but don't have any details.

Try googling on rwrun60 desformat=pdf

Also - as you can see rwrun60 is the 6.0 version, so you might want to try searching on some other versions too...

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98542 is a reply to message #98541]

Wed, 22 December 2004 19:28

Ethan
Messages: 11
Registered: December 2004

Junior Member

searching for that on goodle didn't really help.....I wish ther was some way to asign an IP address to a pdf writer.....or could some sort of macro be written, where you send the data to a certain computer, and it automatically send the data to the pdf writer on it hard drive....

I need oracle and unix for dummies....I'm a mechanical engineer, trying to solve a logistics issue.....wish i had more knowledge of networks..............

Thanx for all your help

Have a happy holiday

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98578 is a reply to message #98542]

Thu, 13 January 2005 14:52

Tim
Messages: 49
Registered: October 2000

Member

For 10.7NCA put the following into the options field for the Concurrent Program definition:

VERSION=2.0b OUTPUT_FORMAT=PDF

Hope that helps.

email if you need more help.

Tim

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98580 is a reply to message #98578]

Fri, 14 January 2005 03:40

Ethan
Messages: 11
Registered: December 2004

Junior Member

this will list a PDF writer as a printer in oracle?

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98593 is a reply to message #98580]

Mon, 24 January 2005 07:43

Tim
Messages: 49
Registered: October 2000

Member

You then need to define a Printer in Oracle that has this PDF Style enabled.

This Style is a place-holder only. It really does not do anything that I know of.

For my company, we then define a PDF driver that then uses Acrobat for UNIX by eay of scripting to convert to Postscript and then print.

cat $PROFILES$.FILENAME | /opt/Acrobat5/bin/acroread -toPostScript -shrink | lp -c -onobanner -d $PROFILES$.PRINTER -n $PROFILES$.CONC_COPIES $PROFILES$.FILENAME

Hope this helps.

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98594 is a reply to message #98593]

Mon, 24 January 2005 08:53

Ethan
Messages: 11
Registered: December 2004

Junior Member

I am told by my IT guy that we can only define a printer in oracel that has an IP addres, which a PDF writer does not have....Do you know how to setup a pritner without an IP adress in such an old version of orcle?(one so old that oracle no longer supports it, and hasn't for years)

Thanx

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98595 is a reply to message #98594]

Mon, 24 January 2005 10:29

Tim
Messages: 49
Registered: October 2000

Member

ONly way around it is to set-up a printer on the network and on the UNIX box.
Then create it in Oracle.

If you are never going to print a hardcopy directly from Oracle adn Unix, then just remove the printer from the network.

Oracle will still have it connected adn UNIX will still have it defined. As long as you set Conc. Request copies to zero, you should be OK.

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98596 is a reply to message #98595]

Mon, 24 January 2005 10:53

Ethan
Messages: 11
Registered: December 2004

Junior Member

how do you setup a pdf writer on the network and unix box to have an IP adress?

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98597 is a reply to message #98596]

Mon, 24 January 2005 10:59

Tim
Messages: 49
Registered: October 2000

Member

You do NOT set-up a PDF writer.

Per my prior message, you configure Reports to output PDF format. Oracle Reports is its own writer.
The file Reports generates then needs to be put on the file system and then if the printer driver is set-up to do so, then print the PDF. Only way to do this is to convert to Postscipt.

If you are not printing a hardcopy, the only reason you are setting up a printer is Oracle requires a printer to print to even if you are setting copies to zero and printing nothing.

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98598 is a reply to message #98597]

Mon, 24 January 2005 11:54

Ethan
Messages: 11
Registered: December 2004

Junior Member

how do i configure Reports to output PDF format?

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98599 is a reply to message #98596]

Mon, 24 January 2005 12:57

Tim
Messages: 49
Registered: October 2000

Member

Per my original message,

'
For 10.7NCA put the following into the options field for the Concurrent Program definition:

VERSION=2.0b OUTPUT_FORMAT=PDF

Hope that helps.'

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98600 is a reply to message #98599]

Mon, 24 January 2005 13:30

Ethan
Messages: 11
Registered: December 2004

Junior Member

where and how do i access this "options field for the Concurrent Program definition"

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98601 is a reply to message #98600]

Mon, 24 January 2005 14:02

Tim
Messages: 49
Registered: October 2000

Member

Sys. Admin- Concurrent - Program - Define.

In the Executable section of this form o nthe left side middle.

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98610 is a reply to message #98597]

Mon, 31 January 2005 11:56

Ethan
Messages: 11
Registered: December 2004

Junior Member

We don't use "oracle reports"...our reports are built into our applications.....

Report message to a moderator

Re: Printing to PDF in older versions of oracle [message #98611 is a reply to message #98610]

Mon, 31 January 2005 12:02

Tim
Messages: 49
Registered: October 2000

Member

Then I've got no clue.
If would then depend on your 'app' can do or how it interacts directly with Unix, etc.

Report message to a moderator

Previous Topic:	install oracle on sco unix
Next Topic:	File transfer from unix to windows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 20:31:57 CDT 2025