Re: PL./SQL.... SQL question...

I don't think you need the quotes in UPPER('$reply') ... UPPER('$reply') is never equal to 'Y', UPPER($reply) may be equal to 'Y' or 'N'.

Vince Laurent wrote:
 (etc)
> set heading on;
>
> /* If the reply is good verify the users intent */
> clear;
> set heading off;
> accept reply prompt 'Are you sure you want to do this? (Y/[N])'
>
> set feedback on;
> set heading on;
>
> begin
> if ( UPPER('$reply') = 'Y' )
> then

(etc) Received on Thu Oct 11 2001 - 16:10:48 CDT