| REPORT ERROR 103 [message #521392] |
Mon, 29 August 2011 10:03  |
 |
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
|
Member |
|
|
hi all,
When am writin one sql statement with case in report formula am getting a error
function FORMULA_N1Formula return Number is
n number;
begin
select (case when sysdate='29-aug-2011' then 0 else 0 end) into n from dual;
return(0);
end;
am getting following error please any one help me.
encountered the symbol "CASE" ......
thanks for all in advance
[Updated on: Mon, 29 August 2011 10:18] Report message to a moderator |
|
|
|
|
|
| Re: REPORT ERROR 103 [message #521438 is a reply to message #521409] |
Mon, 29 August 2011 22:49  |
|
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
|
Member |
|
|
hi vamshi thanks for reply am using
Report Builder 6.0.8.11.3 (report builder 32 bit)
will it support case?
and my oracle version details are
SQL*Plus: Release 8.0.6.0.0 - Production on Tue Aug 30 09:11:45 2011
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[Updated on: Mon, 29 August 2011 22:55] Report message to a moderator |
|
|
|
| Re: REPORT ERROR 103 [message #521446 is a reply to message #521438] |
Tue, 30 August 2011 00:50 |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
Quote:Report Builder 6.0.8.11.3 (report builder 32 bit)
will it support case? I don't think so.
You may change that to something else.case when sysdate='29-aug-2011' then 0 else 0 end
If not, try to use IF clause.
Another suggestion: use to_date on a date string always.
By
Vamsi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
