Re: Bad day, or really not possible?

From: Jon Waterhouse <jonwaterhouse_at_mail.gov.nf.ca>
Date: Tue, 26 Feb 2002 16:36:59 -0330
Message-ID: <3c7bea6f.0@209.128.1.3>

Let me rephrase that:

Why is this a perfectly respectable command in SQLPLUS, or to be executed as dynamic SQL from a stored procedure, but not valid as static SQL in a stored procedure or as a PL/SQL command?

"Jon Waterhouse" <jonwaterhouse_at_mail.gov.nf.ca> wrote in message news:3c7bda8b.0_at_209.128.1.3...
> INSERT into sometable
> (somecolumn)
> SELECT CASE WHEN z <1000 THEN xvalue ELSE yvalue END from
someothertable;
>
> Says it's not expecting the symbol case.
> Just not possible, or am I doing something completely silly?
>
>
>
>
Received on Tue Feb 26 2002 - 14:06:59 CST