| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> Missing Parenthese Error: ORA-00907
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
![]() |
![]() |