Home » Developer & Programmer » Reports & Discoverer » REPORT ERROR 103
REPORT ERROR 103 [message #521392] Mon, 29 August 2011 10:03 Go to next message
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 #521409 is a reply to message #521392] Mon, 29 August 2011 12:10 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Depends on the version you are using..
link1
link2 - Could be an issue with report also.
link3
link4 - Could be an issue with report also.

By
Vamsi
Re: REPORT ERROR 103 [message #521438 is a reply to message #521409] Mon, 29 August 2011 22:49 Go to previous messageGo to next message
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 Go to previous message
vamsi kasina
Messages: 2111
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
But what exactly you want to do here? returning zero in both the cases?
If not, try to use IF clause.

Another suggestion: use to_date on a date string always.

By
Vamsi
Previous Topic: java.io.InvalidClassException: org.omg.CORBA.CompletionStatus; Local class
Next Topic: how to make report high 3.33 inch per page
Goto Forum:
  


Current Time: Wed Apr 01 05:36:25 CDT 2020