Hello,
I had thought that Oracle Forms 10g was now fully in line with the 10g database in terms of the SQL and PL/SQL it supports. However, I notice that while I can use ANSI-syntax joins ('inner join', 'left outer join' etc) in record groups, I can't use them in trigger or procedure PL/SQL. For example, the following:
cursor dist_bacs_csr(c_pln_id plan.id%TYPE)
is
select a.id as a_id
, a.prcng_ccy_cd
, a.sht_nam
, a.dist_bac_key1
, a.dist_bac_key2
from asset a
inner join asset_hldg ash on (a.id = ash.a_id)
inner join bank_acc bac on (a.dist_bac_key1 = bac.key1 and a.dist_bac_key2 = bac.key2)
where ash.inc_acc_ind = 'I'
and ash.pln_id = c_pln_id
order by ash.a_id;
works fine in SQL Plus, but if I try to include it in my form, I get the error 'Encountered the symbol "INNER" when expecting one of the following: ,; for group having intersect minus order start union where connect'
Does anyone know if Oracle plan to support ANSI joins in future versions of Forms? Or is there something obvious I'm missing..?
Cheers,
James
Edited by: James Killeen on Aug 31, 2009 8:29 PM (The alias we normally use for the ASSET table apparently triggered the forum's filter against inappropriate language..! Replaced with a nice harmless 'a' instead...)