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 -> Oracle8 Case expression in PL/SQL

Oracle8 Case expression in PL/SQL

From: Michael <michael.janos_at_originenergy.com.au>
Date: Fri, 06 Oct 2000 07:43:41 GMT
Message-ID: <8rjvrc$nj9$1@nnrp1.deja.com> 






I used the new CASE ... WHEN ... THEN ... ELSE ... END statement in an
insert command. It worked fine in SQL Plus but when I put it into a
procedure I got an error. I cannot find a reference in the
documentation. Can somebody confirm that this expression is not
supported in PL/SQL?



Michael Janos


Origin Energy




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Fri Oct 06 2000 - 02:43:41 CDT












Original text of this message













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