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

Home -> Community -> Usenet -> c.d.o.server -> Re: Using CASE WHEN expression in Package Procedure is not allowed?

Re: Using CASE WHEN expression in Package Procedure is not allowed?

From: Roel Schreurs <schreurs_roel_at_hotmail.com>
Date: 5 Oct 2004 01:30:57 -0700
Message-ID: <321ebdef.0410050030.6c023be0@posting.google.com> 





Bricklen <bricklen_at_zyahoo.zcomz> wrote in message news:<Z8e8d.21262$N%.531_at_edtnps84>...


> Frank van Bortel wrote:

> <snip>

> > iirc, case when syntax is not allowed in 8i;

> > it was introduced in 9iR2...

> 

> Correct, CASE is allowed in sql, but not in pl/sql in 8i.




Well, that solves the case, then. Thanks for your help.
Received on Tue Oct 05 2004 - 03:30:57 CDT












Original text of this message













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