Home » Developer & Programmer » Forms » Error running SQL statement
Error running SQL statement [message #84567] Wed, 31 March 2004 02:52 Go to next message
Krshanu
Messages: 10
Registered: September 2002
Junior Member
Hi,

I have a SQL which is running perfectly fine in SQL*Plus.But when I am opening a cursor using the same SQL it is giving syntax problem.The following parts
in the SQL are giving problems

SELECT
...
LEAD (A.Present_Reading) OVER
(PARTITION BY A.Mchn_Code,A.Prod_Shift
ORDER BY A.Prod_Date DESC) Previous_Reading,
RANK () OVER
(PARTITION BY A.Mchn_Code,A.Prod_Shift
ORDER BY A.Prod_Date Desc) Rk,
...

Is the above functions and partitioning used in SQL are not supported in Forms? I am using Developer2000 Forms6,Oracle 8i on AIX.
Pls. help

Thanks

Report message to a moderator

Re: Error running SQL statement [message #84573 is a reply to message #84567] Wed, 31 March 2004 03:58 Go to previous message
Chadders
Messages: 18
Registered: November 2003
Junior Member
Hi,

no, forms doesn't support use of the analytic functions directly. You'll either have to use
dynamic sql or simply embed the logic in a view.

Report message to a moderator

Previous Topic: form parameters
Next Topic: Froims server on windows XP user1.pin(20): OS_ERROR
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 31 18:47:44 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.