Re: PL/SQL Exception handling

andrewst_at_onetel.net.uk (Tony) wrote in message news:<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';
>
> 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.

So it's not that PL/SQL isn't doing it's job, it's SQL*Plus.

Thanks! Received on Mon Mar 24 2003 - 15:08:50 CET