Re: PL/SQL Exception handling
From: Jeff <jeff_at_work.com>
Date: Fri, 21 Mar 2003 14:51:16 GMT
Message-ID: <b5f8t4$qd4$1_at_cronkite.cc.uga.edu>
Date: Fri, 21 Mar 2003 14:51:16 GMT
Message-ID: <b5f8t4$qd4$1_at_cronkite.cc.uga.edu>
In article <6e439c43.0303210613.7179c0f5_at_posting.google.com>, david.mcmullen_at_mail.va.gov (davidmac) wrote:
>> And you expect SQL*Plus to kick in and ask about the
>> values of PNAME, PPHONE and PSPECIALITY? No dice.
>> That's plus, not pl/sql
>
>It asks for the values if the exception is not raised. that is the problem.
That's because all of the substitution values (&) of your anonymous block are made by SQL*plus at compile-time, not run-time. By the time it reaches the server, those values are hard-coded into the block. Received on Fri Mar 21 2003 - 15:51:16 CET