Home » Developer & Programmer » Forms » Can a form Function be called from Record group - Form 6i (Oracle Form 6i)
Can a form Function be called from Record group - Form 6i [message #594047] Thu, 22 August 2013 23:59 Go to next message
anoopmanagoli
Messages: 20
Registered: August 2012
Location: india
Junior Member
Hi All,


I want to create Query based LOV in Oracle Form 6i.


The Query i write in record group is as follows :


SELECT DISTINCT

nr.rec_locator AS rec_locator,

car.car_dte AS car_date,

Get_car_info(:CON.REF_NO) AS car_number

FROM car_list_entries car,

contact_details cdt,

name_records nr

WHERE car.car_id = cdt.car_id

AND cdt.nr_id = nr.id

AND cdt.con_ref_no = :CON.REF_NO


/* Get_car_info( x NUMBER) is a Form Function */


this throws an error :

It says

frm-12001 (Cannot Create the Record Group (Check your Query)

Kindly guide how can i use the Form function to get the desired output.



Many Thanks,

Anoop.
Re: Can a form Function be called from Record group - Form 6i [message #594066 is a reply to message #594047] Fri, 23 August 2013 02:45 Go to previous messageGo to next message
cookiemonster
Messages: 10593
Registered: September 2008
Location: Rainy Manchester
Senior Member
Please read and follow How to use [code] tags and make your code easier to read?

If you run that query in sqplus does it work?
Re: Can a form Function be called from Record group - Form 6i [message #594091 is a reply to message #594047] Fri, 23 August 2013 06:40 Go to previous message
DrabJay
Messages: 23
Registered: May 2013
Junior Member
You cannot do this. Either the function has to be exist in the database or you can use the form function to programmatically build the record group using the various record group built-ins.

John
Previous Topic: oracle 6i with window 7
Next Topic: Problem in saving, no errors shown and neither record is inserted
Goto Forum:
  


Current Time: Thu Apr 24 23:44:43 CDT 2014

Total time taken to generate the page: 0.10302 seconds