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

Home -> Community -> Usenet -> comp.databases.oracle -> Missing Parenthese Error: ORA-00907

Missing Parenthese Error: ORA-00907

From: Terry Coccoli <request_at_ifneeded.com>
Date: Mon, 05 Apr 2004 22:08:15 GMT
Message-ID: <iNkcc.1553725$iA2.185047@news.easynews.com>

Anyone see anything wrong with this:

create or replace function HourParser(DayTimeValue In Integer) return varchar2 is

   Result varchar2(20);
begin

      Execute Immediate
      'SELECT CASE (WHEN :x > 1) THEN "YES" END
       FROM DUAL' Into Result Using DayTimeValue;

Return(result);
end HourParser; Received on Mon Apr 05 2004 - 17:08:15 CDT

Original text of this message

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