Home » Developer & Programmer » Precompilers, OCI & OCCI » analytic functions in Pro*C - rank()
analytic functions in Pro*C - rank() [message #121274] Fri, 27 May 2005 06:22 Go to next message
e.shivakumar
Messages: 1
Registered: May 2005
Location: chennai
Junior Member
Hi ,

I am using rank() function in declaring a cursor within proc.

after compiling the code , i get the below mentioned error.
The same problem is faced by Mr.martin and he had posted the messge Jan 2003 message number 94355.

Error:
Error at line 3745, column 16 in file test.cpp
rank() over (partition by classno order by evnsents de
sc) "ranking"
...............1
PCC-S-02201, Encountered the symbol "(" when expecting one of the following:
, into, from,
Error at line 0, column 0 in file test.cpp
PCC-F-02102, Fatal error while doing C preprocessing
make: 1254-004 The error code from the last command is 1.


Please help,
A response is very much appreciated.

Thanks
Siva
Re: analytic functions in Pro*C - rank() [message #121423 is a reply to message #121274] Sat, 28 May 2005 15:40 Go to previous messageGo to next message
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member

Please post the entire SQL statement.

Have you tested the SQL statement within SQLPLUS?

Kind regards,
Michael Hartley, http://www.openfieldsolutions.co.uk
Re: analytic functions in Pro*C - rank() [message #584750 is a reply to message #121274] Fri, 17 May 2013 07:16 Go to previous messageGo to next message
busettymanohar
Messages: 2
Registered: May 2013
Location: chennai
Junior Member
Hi,

I am getting PRO*C Error when i use partition in select query

and getting error :

Error at line 174, column 46 in file crerodef.pc
(SELECT CRO.*,lead(CRO.ENTDATE) over (partition by CRO.CO_ID order by CRO.ENTDATE) as N_ENTDATE
.............................................1
PCC-S-02201, Encountered the symbol "(" when expecting one of the following:

, into, from,


Kindly help me.
Re: analytic functions in Pro*C - rank() [message #584761 is a reply to message #584750] Fri, 17 May 2013 07:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the whole as well as Pro*C version and Oracle client version (with 4 decimals).

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

Regards
Michel

[Updated on: Fri, 17 May 2013 07:59]

Report message to a moderator

Re: analytic functions in Pro*C - rank() [message #584763 is a reply to message #584750] Fri, 17 May 2013 08:12 Go to previous messageGo to next message
busettymanohar
Messages: 2
Registered: May 2013
Location: chennai
Junior Member

Please find versions of Oracle and Pro*c Versions :


Pro*C/C++: Release 11.2.0.3.0
Oracle Version : 11.2.0.2.0.64
Re: analytic functions in Pro*C - rank() [message #584776 is a reply to message #584763] Fri, 17 May 2013 10:16 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK now the code around the error (and read the link to know how to format it).

Regards
Michel
Previous Topic: ODCIIndexInsert parameters
Next Topic: Ora-01002 by select for update in SQL statement
Goto Forum:
  


Current Time: Thu Mar 28 06:24:30 CDT 2024