In article <378DC1C2.23DC_at_space.se>,
Henrik Otto <ottoh_at_space.se> wrote:
> In sqlplus you can read in the commands from a file with the @-sign,
is
> it possible to do the same in pl/sql, i.e. use a procedure for loading
> stuff thats in a file.
>
> /Henrik
>
See the utl_file package which provides pl/sql a means of reading and
writing text files on the database server. If you run your application
on an application server and the database on a separate box then you
will need to use a different technique such a using an Oracle pipe via
dbms_pipe to pass data back and forth.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Jul 15 1999 - 08:41:29 CDT
