Re: HTML and Oracle using UTL

From: Patrick Bogers <p.bogers_at_scope-mt.nl>
Date: 1998/03/06
Message-ID: <6dov5t$7oe@news.euro.net>#1/1

You can try UTL_FILE_DIR=* in the init.ora

David F. Clipsham wrote in message ...
>I am creating HTML with <-- Special Comments --> in it so that I can use
>PL/SQL to recognize the special comments and add database generated
>material. For example:
>
><Body>
><-- Insert Oracle Table Here -->
></Body>
>
>So, I want to read this html file from a unix system with Oracle 7.3.2
using
>Oracle's UTL_FILE package. When the PL/SQL code sees the special comment
in
>one of the lines it reads in, it replaces the comment with the results of a
>query.
>
>I have seen that it is necessary to have the location of any files used by
>UTL_FILE initialized in the init.ora file for the database instance, and I
>have done so. The problem is that I still get a trappable
>UTL_FILE.INVALID_PATH error every time I try to open my html file for
>reading using the FOPEN command.
>
>Can anyone shed any light on proper formatting of the necessary lines in
the
>init.ora file? Is there something else that might be the problem?
>
>Thanks, Dave Clipsham
>dfclipsham_at_mindless.com
>
>
Received on Fri Mar 06 1998 - 00:00:00 CST

Re: HTML and Oracle using UTL_FILE