Re: PL/SQL Exception handling
From: Tony <andrewst_at_onetel.net.uk>
Date: 21 Mar 2003 04:06:09 -0800
Message-ID: <c0e3f26e.0303210406.42d19380_at_posting.google.com>
Date: 21 Mar 2003 04:06:09 -0800
Message-ID: <c0e3f26e.0303210406.42d19380_at_posting.google.com>
david.mcmullen_at_mail.va.gov (davidmac) wrote in message news:<6e439c43.0303200935.7b2a7bc4_at_posting.google.com>...
> are these lines the problem?
>
> v_PHYS_NAME := '&PNAME';
> v_PHYS_PHONE := '&PPHONE';
> v_PHYS_SPECIALTY := '&PSPECIALTY';
[Quoted] Yes, they are. PL/SQL cannot interact with the user, as it runs in the server not in the client (which is SQL Plus in this case). You would need to write a client program (Oracle Forms, PSP, ASP, whatever) to do this. Received on Fri Mar 21 2003 - 13:06:09 CET