Re: UTL_FILE - Print Novell Network

Sybrand,

I don't think the OP is trying to run Oracle on Novell; if I understand correctly he's trying to print (from Oracle on Windows 2000) to to a UNC path. That's a slightly different question, isn't it?

Paul

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:u6lhsdo185d532_at_corp.supernews.com...
>
> "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
>
>
>
Received on Wed Feb 13 2002 - 17:20:07 CST