Home » Developer & Programmer » Reports & Discoverer » error in using dense_rank() in formula column (merged by CM) (oracle 10g)
error in using dense_rank() in formula column (merged by CM) [message #456683] Wed, 19 May 2010 04:12 Go to next message
manisha_borade
Messages: 49
Registered: May 2010
Member
function CF_sr_noFormula return Number is
sr_num number;
begin
select DENSE_RANK () OVER(PARTITION BY order_number ORDER BY rownum )rn into sr_num
FROM oe_order_headers_all where header_id = :header_id ;
return sr_num;
end;

i am using dense_rank ()but it showing error
Re: error in using dense_rank() in formula column [message #456685 is a reply to message #456683] Wed, 19 May 2010 04:15 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I cannot see any error here
Please read the forum guide lines before posting.http://www.orafaq.com/forum/t/88153/0/

whats your product & version number

sriram Smile

[Updated on: Wed, 19 May 2010 04:23]

Report message to a moderator

error in formula column [message #456691 is a reply to message #456683] Wed, 19 May 2010 04:27 Go to previous messageGo to next message
manisha_borade
Messages: 49
Registered: May 2010
Member
function CF_sr_noFormula return Number is
sr_num number;
begin
select DENSE_RANK () OVER(PARTITION BY order_number ORDER BY rownum )rn into sr_num
FROM oe_order_headers_all where header_id = :header_id ;
return sr_num;
end;


-------------Error ----
Error 103 at line 4 ,column 31
Encountered the symbol "(" when expecting one of the following
,from into bulk
Re: error in formula column [message #456692 is a reply to message #456691] Wed, 19 May 2010 04:29 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
What version of the DB are you using?
What version of reports are you using?
Re: error in formula column [message #456693 is a reply to message #456692] Wed, 19 May 2010 04:30 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that Reports' PL/SQL engine (i.e. formula columns, procedures, ...) do not support analytical functions. You can, however, use them in a report query.
Re: error in formula column [message #456696 is a reply to message #456692] Wed, 19 May 2010 04:35 Go to previous messageGo to next message
manisha_borade
Messages: 49
Registered: May 2010
Member
reports 9.0.4.0

dabase 10g
Re: error in formula column [message #456699 is a reply to message #456696] Wed, 19 May 2010 04:49 Go to previous message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Move the query into a database function.
Call that from your formula column.
Previous Topic: serial number setings
Next Topic: Reports Consuming CPU
Goto Forum:
  


Current Time: Fri Aug 14 09:53:12 CDT 2020