Re: UTL_FILE - Print Novell Network

"Svend Jensen" <Master_at_OracleCare.Com> wrote in message news:3C6AACCE.8020302_at_OracleCare.Com...
> SUSOTT_at_amnutrition.com wrote:
>
> > I currently have Oracle 8.1.7 on Windows 2000.
> >
> > We are developing a production module where an operator will press a key
and
> > the the module will "automatically" print out a pallet tag form. We are
> > having problems getting this to work. My current thought is to set
UTL_FILE
> > = "\\server\volume\print queue" (Novell UNC path) (I realize I will need
> > separate lines for each print queue.). Then to open the print queue
using
> > FOPEN [print queue] and writing to the file and then closing it.
> >
> > Will the scenerio work?
> > If the form will run on the client machines, would using LPT1 work or
will
> > the program still be ran at the server?
> > Is there a different method to accomplish this?
> > Idealy, I would like the code ran on the client and directed to LPT1.
> >
> > Currently, we have a COBOL program which writes directly to LPT1 (we
send a
> > layout file at the start and then a data file for each pallet tag we
need
> > printed).
> >
> >
> >
> >
>
> I have encounted some 'features' using utl_file on win2k and 8.1.7. as
> having named the utl_file_dir = share_name (S:\some_dir) for
> \\server\path network share located on remote file server (non oracle
> server), would not work. If I created the same share local (on oracle
> server) it worked. This was NT/Win2k networking, not novell.
> To get rid of this 'feature' I had to set utl_file_dir = '*', witch I
> dont like. I havn't had the opotunity to investigate any further.
> Also the space in the path (print queue) might give you some problems.
>
> rgds
> /Svend Jensen
>

Oracle for Novell will be history soon anyway, so it doesn't really matter

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address