Re: SQL*ReportWriter (unable to print)

you may want to check the way you handle arguments passed to your file. spoolcmd will recieve

arg1 - file name to be printed
arg2 - line printer default (File/Spool device name on parameter form)
arg3 - file disposotion flag (to delete file or not after printing)
arg4 - number of copies to print

spolcmd will then prepare a command like

lp -c -d{printer name} -s -n{number of copies} file_name_to_print the chances are

1. you have not given correct printer name (the name that will appear after "lpstat -t" on most unix macines)
2. your handling of parameters is such that lp never gets the filename

one more suggestion -

instead of new spoolcmd why don't you try writing your own "lp" shell script. put it in path before "lp".

hope this helps.

Aniruddha Kortikar (kortikar_at_mipos2.intel.com)

>>>>>>>

 In article <1992Jun2.182511.11796_at_deepthought.uucp> Neil Greene <deepthought!neil_at_ms.uky.edu> writes:
>I am using SQL*ReportWriter on a NeXTcube running Oracle RDBMS 6.x.x.x.x
>
>I have linked the proper print command to
>$ORACLE_HOME/sqlreport/admin/printer/spoolcmd. When executing a report, I then
>set DESTYPE=Printer, Filename/Spool Device=lpr or /usr/ucb/lpr,
>DESCRIP=decwide, etc.
>
>However, report writer will not print. I receive the following error every
>time I issue the command, "Cannot perform requested print operation."
>
>Any ideas???
>--
>Neil Greene
>ARCI, Inc.
>Kentucky NeXT User Group, Inc.
>Phone: 606.254.4060
Received on Wed Jun 03 1992 - 19:17:05 CEST