Home » Developer & Programmer » Forms » Print an Oracle Report 10g using UNIX
Print an Oracle Report 10g using UNIX [message #448913] Thu, 25 March 2010 12:32 Go to next message
maber
Messages: 8
Registered: February 2010
Location: hyderabad
Junior Member
Hello All,

I installed a printer(HP Laserjet 3390) in UNIX(Solaris).Followed the instructions while installing as to the path it should be present for Reports to read it etc.,
Also modified the uiprint.txt file with the desired .hpd file.
Logging on to the UNIX machine, I am using the below command
rwrun.sh report=xyz.rdf userid=XXXX/XXX@xxx paramform=no p_orig_org='0825' desformat=pdf destype=printer desname=xxxx batch=yes
This command invokes the printer and
^[%12345X@PJL
@PJL SET RESOLUTION=300
@PJL SET PAGEPROTECT=OFF
@PJL SET ENTER LANGUAGE=PCL
^[%1A^[E^
@PJL RESET
^[%12345X

is what it prints.
Realizing that this is because of the missing parameter,tried to change paramform=yes but I am not sure how to pass the parameter.
Can you please help me in this regard
Re: Print an Oracle Report 10g using UNIX [message #448923 is a reply to message #448913] Thu, 25 March 2010 16:20 Go to previous messageGo to next message
gregor
Messages: 86
Registered: March 2010
Location: Germany
Member
Hi maber,

if seams to me, as if the printer isn t defined correct.
( Parameter passing is a second step)

in the uiprint.txt file
the TK_PRINTER environment variable or
the PRINTER environment variable
is set to the printer name.

Example: printerxx

printerxx:PostScript:2:test:default.ppd:

--------------
p_orig_org='0825' is one example of user_defiend Parameter

Re: Print an Oracle Report 10g using UNIX [message #449058 is a reply to message #448923] Fri, 26 March 2010 08:16 Go to previous messageGo to next message
maber
Messages: 8
Registered: February 2010
Location: hyderabad
Junior Member
Hi Gregor,

This is a PCL type printer and thus
uiprint.txt is set to
printerxx:PCL:5:test:ui4.hpd:

The problem here is it is a transition work and I am taking over the work from my ex-colleague...if p_orig_org is already given a value do you think that paramform should be set to 'YES'

Thank you for the quick response!!!! Smile
Re: Print an Oracle Report 10g using UNIX [message #450168 is a reply to message #449058] Mon, 05 April 2010 09:14 Go to previous messageGo to next message
maber
Messages: 8
Registered: February 2010
Location: hyderabad
Junior Member
Hello....

I am still working on this and seek your help....please let me know the changes i need to make for the successful printing of the reports.
Re: Print an Oracle Report 10g using UNIX [message #451319 is a reply to message #450168] Wed, 14 April 2010 00:50 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

Can you get any report to print on this printer?

David
Re: Print an Oracle Report 10g using UNIX [message #451466 is a reply to message #451319] Wed, 14 April 2010 19:04 Go to previous messageGo to next message
maber
Messages: 8
Registered: February 2010
Location: hyderabad
Junior Member
No Martin!!! I am still waiting on that.....tried reading different material related to this stuff.....but I a'int able to put head and tail together.....

Appreciate your concern and would be glad if any solution posted.

Thankyou!!!!
Re: Print an Oracle Report 10g using UNIX [message #451478 is a reply to message #451466] Thu, 15 April 2010 01:14 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
My name is 'David'. It is the name that I place at the end of all of my posts.

Can you print any report on any other printer?

Are you the only person at your facility running Forms and Reports?

Is this your first form?

Is this your first report?

David
Re: Print an Oracle Report 10g using UNIX [message #451629 is a reply to message #451478] Thu, 15 April 2010 19:16 Go to previous messageGo to next message
maber
Messages: 8
Registered: February 2010
Location: hyderabad
Junior Member
This neither my first form or report....but first trying to print a report using UNIX.

We have others in the team also working on forms....
I am not able to print the report in any other printer...

Thank you for the interest but if you think I have to set something during form creation then I can check that either....

Thanks!!!
Re: Print an Oracle Report 10g using UNIX [message #451640 is a reply to message #451629] Thu, 15 April 2010 20:46 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You say "first trying to print a report using UNIX".

Does this mean that your current environment is Windows and that printing works on your windows attached printers but now you are trying to print on a network printer through the Unix network?

Can you get any application on your PC to print to this Unix printer?

David
Re: Print an Oracle Report 10g using UNIX [message #451737 is a reply to message #451640] Fri, 16 April 2010 08:19 Go to previous messageGo to next message
maber
Messages: 8
Registered: February 2010
Location: hyderabad
Junior Member
David,

Yes thats perfectly right....I am in Windows and trying to print through a printer connected in UNIX environment.

I can print word docs,spreadsheets etc., through this printer...hope this is what you were referring to in the line 'Can you get any application on your PC to print to this Unix printer?'

Thanks!!!
Re: Print an Oracle Report 10g using UNIX [message #452410 is a reply to message #451737] Wed, 21 April 2010 23:37 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sorry, but I can't help. I can only suggest googling and searching this site for defining the 'alias' to the Unix printer and how to use it.

You could also post your code and someone may see the problem with your alias.

David
Re: Print an Oracle Report 10g using UNIX [message #452523 is a reply to message #452410] Thu, 22 April 2010 08:10 Go to previous message
maber
Messages: 8
Registered: February 2010
Location: hyderabad
Junior Member
No problem. Once again,appreciate your concern.

Thank you..
Previous Topic: hierarchical Tree
Next Topic: Record 1/? "Counter"
Goto Forum:
  


Current Time: Fri Sep 20 05:28:24 CDT 2024