RE: Script and control file

Inside Pl/SQL u cannot use the host command.. HOST is Sql*PLUS command not a SQL. So, u cannot use with in Pl?SQL

Rajaram

-----Original Message-----
From: William Beilstein [SMTP:BeilstWH_at_obg.com] Sent: Tuesday, May 29, 2001 12:08 PM

To:     Multiple recipients of list ORACLE-L
Subject:        Re: Script and control file

see the host command in pl/sql

>>> 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: Quaglio Andrea
  INET: Andrea.Quaglio_at_semagroup.it 

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).

--
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).

NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajaram
  INET: rajaram_k_at_netzero.net

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).