Re: Script and control file

As Jared pointed out (shame on me), there is no host command in PL/SQL, the only place where the host command is supported in in sqlplus and forms.

>>> Jared Still <jkstill_at_cybcon.com> 05/29/01 02:10PM >>>
On Tuesday 29 May 2001 09:07, William Beilstein wrote:
> see the host command in pl/sql

Bill, I know you know this: there is no host command in pl/sql.

Assuming you meant sqlplus. :)

Jared

>
> >>> Andrea.Quaglio_at_semagroup.it 05/29/01 11:15AM >>>
>
> First of all, I'm a beginner to SQL/SQL Loader.
> Currently,I'm working with Oracle 8.
> I would like to know if it's possible invoke SQL Loader inside a script.
>
> Example:
> - inside the script I want to create a new table TABLE1
> - copy some data inside TABLE1 using SQL loader
> - work on TABLE1 using SQL language.
>
> Is it possible do this inside a .sql file ?
>
> Thanks,
> Andrea

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).