Re: UTL_FILE - Print Novell Network

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 - 12:13:34 CST