Re: plsql - call system command
Date: Wed, 16 Jun 1999 17:54:16 +0100
Message-ID: <7k8hdg$800$1_at_news.inet.tele.dk>
Francesco Grasso <francesco.grasso_at_istat.it> wrote in message
news:01beb80f$549195c0$2678120a_at_Shinano21.istat.it...
> Excuse me!
> I have a big problem! I would like to know how to execute a system command
> by a PL/SQL procedure in UNIX.
> I tried to use the 'host' command but it doesn't work.
> It's strange: it works in a SQL script, but not within a Pl-Sql!
> My work is on yours hands :-)
> my e-mail address is:
> vignola_at_istat.it
> Thanks in advance
HOST is a SQL*Plus command, not a PL/SQL feature. If you want to be able to
do this with Oracle7 take a look at
http://www.oracle.com/database/features/plsql/plexdoc_toc.html. If you're
running Oracle 8.0 or 8.1, you can use External Procedures, in 8.1 you can
create a Java stored procedure.
HTH. Finn Received on Wed Jun 16 1999 - 18:54:16 CEST