OraFAQ Forum: Reports & Discoverer » error in using dense_rank() in formula column (merged by CM)

Home » Developer & Programmer » Reports & Discoverer » error in using dense_rank() in formula column (merged by CM) (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error in using dense_rank() in formula column (merged by CM) [message #456683]

Wed, 19 May 2010 04:12

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

Report message to a moderator

Re: error in using dense_rank() in formula column [message #456685 is a reply to message #456683]

Wed, 19 May 2010 04:15

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

manisha_borade
Messages: 49
Registered: May 2010

Member

Report message to a moderator

Re: error in formula column [message #456692 is a reply to message #456691]

Wed, 19 May 2010 04:29

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

What version of the DB are you using?
What version of reports are you using?

Report message to a moderator

Re: error in formula column [message #456693 is a reply to message #456692]

Wed, 19 May 2010 04:30

Littlefoot
Messages: 21823
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.

Report message to a moderator