OraFAQ Forum: Forms » Can a form Function be called from Record group

Home » Developer & Programmer » Forms » Can a form Function be called from Record group - Form 6i (Oracle Form 6i)

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

Can a form Function be called from Record group - Form 6i [message #594047]

Thu, 22 August 2013 23:59

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.

Report message to a moderator

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

cookiemonster
Messages: 13966
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?

Report message to a moderator

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

DrabJay
Messages: 32
Registered: May 2013

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 08:38:18 CDT 2025