Re: NEWBIE: SQLPLUS Login Question

From: David Scott <dscott_at_is.net>
Date: 1995/10/18
Message-ID: <dscott-1810952151280001_at_dscott.is.net>#1/1

In article <DGLrxF.Gn3_at_corsair.daytonoh.attgis.com>, (murphbd) wrote:

> I am trying to write a sqlplus script to test for a proper connection to a
> database. I am just learning SQLPLUS and ORACLE. I wrote the following:
>
> accept pwd prompt 'Enter password :' hide
> BEGIN
> connect ap/&&pwd
> EXCEPTION
> WHEN LOGIN_DENIED THEN
> RAISE
> END;
>
> I get the prompt okay, but then I see the following after putting a password
> and pressing the ENTER key:
>
> Enter AP password :
> 7
> 7
>
> What is happening here? It looks to me like I am in some construct loop to
> enter data. Can anyone make some suggestions! I am trying to follow the code
> examples in the PL/SQL User Guide and Reference 2.0 from Oracle(Page 5-4).
> Thanks!

You should be able to just:
SET VERIFY OFF
in order to remove the prompt (old value, new value) lines. I haven't tried this on your script, but it should work.

---

David Scott
...how can I keep from singing?
email: dscott_at_is.net

---

Received on Wed Oct 18 1995 - 00:00:00 CET