Re: UTL_FILE - Print Novell Network

have also experimented with unc
(OPS/RMAN trying to get archives across nodes via unc)

Did only work if oracle service was running under local account (not system).

regards

s.kapitza

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
Received on Wed Feb 13 2002 - 16:32:34 CST