Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Bad day, or really not possible?

Re: Bad day, or really not possible?

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Tue, 26 Feb 2002 21:20:34 GMT
Message-ID: <3C7BFC22.6540BD64@ci.seattle.wa.us>


Because up until version 9i the SQL and PL/SQL engines were separate. So when the command was added it was put into the SQL engine but had not yet been put into the PL/SQL engine.

That will not happen again as they have been merged.

Daniel Morgan

Jon Waterhouse wrote:

> 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 - 15:20:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US