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_at_news.easynews.com>
Date: Mon, 05 Apr 2004 22:08:15 GMT
Message-ID: <iNkcc.1553725$iA2.185047_at_news.easynews.com>
Anyone see anything wrong with this:
create or replace function HourParser(DayTimeValue In Integer) return
varchar2 is
Result varchar2(20);
Return(result);
begin
Execute Immediate
'SELECT CASE (WHEN :x > 1) THEN "YES" END
FROM DUAL' Into Result Using DayTimeValue;