Oracle-L: Re: PL/SQL - can't accept user input

From: <Jared.Still_at_radisys.com>
Date: Tue, 04 Nov 2003 15:14:27 -0800
Message-ID: <F001.005D5934.20031104151427@fatcity.com>

This should get you started

HTH Jared

SQLPATH=''
USER_INPUT='' while [ -z "$USER_INPUT" ]
do

        echo Please enter a table owner:
        read USER_INPUT

done

echo $USER_INPUT

sqlplus /nolog <<EOF
set echo on
connect scott/tiger
select table_name
from all_tables
where owner = upper('$USER_INPUT');
EOF "Saira Somani-Mendelin" <saira_somani_at_yahoo.com> Sent by: ml-errors_at_fatcity.com
11/04/2003 01:49 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        PL/SQL - can't accept user input - then how?

List,

Please forgive the repetitious nature of this query, but I haven't yet found an answer that satisfied me.

Environment: AIX 5.1 Oracle 8.1.7

Trying to create an SQL script which calls a procedure to update a record based on information provided by the user via a screen prompt. I know PL/SQL is not interactive by nature.

I have tried the ACCEPT command in the .sql script before the procedure call, which is wrapped in a shell script but it doesn't wait for my input, just carries on executing the rest of the .sql script.

I am now thoroughly confused about how to do this. And I doubt I am the only one. I do need the user to provide me with a parameter so I can locate the record for update.

Don't hesitate to tell me to RTFM or book or website, just tell me WHICH ONE(S) to read :)

Thanks much,
Saira

--

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

Author: Saira Somani-Mendelin
INET: saira_somani_at_yahoo.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.net
--

Author:
INET: Jared.Still_at_radisys.com

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

Re: PL/SQL - can't accept user input - then how?