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

From: Saira Somani-Mendelin <saira_somani_at_yahoo.com>
Date: Tue, 04 Nov 2003 13:49:32 -0800
Message-ID: <F001.005D5928.20031104134932@fatcity.com>

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). Received on Tue Nov 04 2003 - 15:49:32 CST

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