Oracle-L: RE: How to pass value from SQL*Plus to Unix scripts?

From: Fink, Dan <Dan.Fink_at_mdx.com>
Date: Tue, 22 Oct 2002 14:20:03 -0800
Message-ID: <F001.004F06FE.20021022142003@fatcity.com>

There are excellent examples at the ORAFAQ site.

Try http://www.orafaq.com/faqunix.htm#UNIXVAR

Dan Fink

-----Original Message-----
Sent: Tuesday, October 22, 2002 3:54 PM
To: Multiple recipients of list ORACLE-L

Greetings,

SQL> select value from v$nls_parameters where parameter='NLS_CHARACTERSET';

VALUE

US7ASCII Now in the Unix shell script I want to pass this character set as follows

/user/oracle/export/export_db.sh /uexports tcqscm system manager AMERICAN_AMERICA.US7ASCII How can I pass the character set to the export script?

Thanks,
Ashoke
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mandal, Ashoke
INET: ashoke.k.mandal_at_medtronic.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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: Fink, Dan
INET: Dan.Fink_at_mdx.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------