Home » Developer & Programmer » Forms » error ROW_NUMBER() in form
error ROW_NUMBER() in form [message #622313] Mon, 25 August 2014 02:13 Go to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
my form have this code
	FOR I IN (
					SELECT ROW_NUMBER() OVER (ORDER BY IDE_AREA) R_NUM,
								 IDE_AREA						   
						  FROM PMS_AREAS
						 WHERE PMS_AREAS.ARSTU_IDE_PK_ARSTU LIKE 
               (APP_HSM_HFL_PKG.GET_ARSTU_HOT_FINISH_LINE_FUN
                   (APP_HSM_HFL_PKG.GET_COMPANY_FROM_AREA_FUN(:CONTROL_SEARCH.ITEM_AREA_ID))||'%COIL-STK%' 
               )
						   AND PMS_AREAS.FLG_PROD_MAIN_PARK_AREA = 1   
               AND NVL(PMS_AREAS.FLG_PROD_PARK_POS_AREA,0)=0       
						 ORDER BY 2)
				 LOOP

but this have error?
(More codes not listed)
Re: error ROW_NUMBER() in form [message #622317 is a reply to message #622313] Mon, 25 August 2014 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Error? What error? I don't see any in your text.



Re: error ROW_NUMBER() in form [message #622319 is a reply to message #622317] Mon, 25 August 2014 02:22 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which Forms version is it? Note that - usually - Forms' PL/SQL engine doesn't support all features available in database's PL/SQL engine. Therefore, it is possible that your Forms can't interpret analytic ROW_NUMBER function. If that's the case, you'll have to rewrite that code (or upgrade your Forms version, which might be a problem).
Re: error ROW_NUMBER() in form [message #622320 is a reply to message #622317] Mon, 25 August 2014 02:24 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
please see attachment file
  • Attachment: error.JPG
    (Size: 50.22KB, Downloaded 889 times)
Re: error ROW_NUMBER() in form [message #622323 is a reply to message #622320] Mon, 25 August 2014 02:46 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid I was right.
Re: error ROW_NUMBER() in form [message #622325 is a reply to message #622323] Mon, 25 August 2014 03:08 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
my oracle form is 11g
Re: error ROW_NUMBER() in form [message #622326 is a reply to message #622325] Mon, 25 August 2014 03:11 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As I don't use it, I can't test it.

What happens when you run that piece of code:
SELECT ROW_NUMBER() OVER (ORDER BY IDE_AREA) R_NUM,    --> Forms report error at the open bracket here: (ORDER
       IDE_AREA						   
FROM PMS_AREAS
in SQL*Plus?
Re: error ROW_NUMBER() in form [message #622328 is a reply to message #622326] Mon, 25 August 2014 03:36 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
in plsql no error.
but in form11g have error!
Re: error ROW_NUMBER() in form [message #622333 is a reply to message #622328] Mon, 25 August 2014 03:59 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
11g Forms is new, I believe that its PL/SQL supports analytic functions ...

Sorry, I don't have any other ideas.
Re: error ROW_NUMBER() in form [message #622358 is a reply to message #622333] Mon, 25 August 2014 12:39 Go to previous messageGo to next message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
Oracle Forms does not support Analytical Functions (that includes Forms 11g R2 - version 11.1.2.x.x). You will need to create a view in your database and then select from the view in your Form.

Craig...
Re: error ROW_NUMBER() in form [message #622369 is a reply to message #622358] Mon, 25 August 2014 13:41 Go to previous message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Huh, I was too optimistic, hoping that Forms finally doesn't lag behind the database.
Previous Topic: ole2 package
Next Topic: Mouse Navigation Problem
Goto Forum:
  


Current Time: Wed Apr 24 13:17:55 CDT 2024