Re: UTL_FILE - Print Novell Network

oracle on one machine cannot access the paths on a novell server, as oracle is using the i/o kernel to directly access your local servers devices.
also setting utl_file_dir = '*' is a real big mistake and a real big security hole, as it bypasses any server side security and gives access directly to root programs (you can write/read absolutly ANY file on the server), on the machine that the oracle resides on.

also writing to lpt1 is a little different that dumping a file directly into the printer Queue on the novell server, as output directed to lpt1 goes through a printer driver( converts the output to printer specific codes) and security that informs the server that a job is ready, it would depend on how the print queue is implemented at the novell end and its security.

you might try a java module on the client or server, that is called by the oracle, as java is a bit more printer friendly than oracle and would give you cleaner code that is easier to maintain and implement.

steve   

<SUSOTT_at_amnutrition.com> wrote:

> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3c6b7952$0$236$ed9e5944_at_reading.news.pipex.net...
> > "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.
> > <snip>
> > >
> > > Oracle for Novell will be history soon anyway, so it doesn't really
> matter
> >
> > However he clearly isn't using Oracle for Novell. I'd (hesitantly) suggest
> > installing gateway services for netware on the machine and using a mapped
> > drive. You may find it better though to install the novell client and
> leave
> > the machine logged in to achieve the same effect.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> >
> After talking with the network guru, we decided to go ahead and use the
> Novell Client. Even after installing the client, I am unable to write a
> file to a network path, let alone print to the network printer object.
> (The machine uses an account with access to the file path and printer
> objects and outside of Oracle, has no problems working with the network.)
>
> Is something like this possible through reports or forms?
Received on Fri Feb 15 2002 - 15:47:11 CST