input into pl-sql from sql*plus
From: Joe Fulson-Woytek <joefw_at_eosdev2.gsfc.nasa.gov>
Date: 5 Aug 1994 21:08:43 GMT
Message-ID: <31u9os$aj1_at_paperboy.gsfc.nasa.gov>
Date: 5 Aug 1994 21:08:43 GMT
Message-ID: <31u9os$aj1_at_paperboy.gsfc.nasa.gov>
The PLSQL (Version1 with Oracle6) manual has nice examples
with PRO*C where a C variable is used inside an embedded
PLSQL block. I'd like to do the same thing with SQL*PLUS,
but can't find a way to pass the info into the block. What I'd
like to do is something like:
ACCEPT pid PROMPT ' enter person_id:'
DECLARE
reqid number;
BEGIN
SELECT REQUEST_ID INTO reqid WHERE PERSON_ID=pid;
END:
Any ideas?
Joe Woytek
joefw_at_daac.gsfc.nasa.gov
Received on Fri Aug 05 1994 - 23:08:43 CEST