Frm-10902 invalid sql query

hi i have the following sql running in toad IDE
  select obj_child, child_id, obj_id, obj_name, obj_parent, parent_id
from
(
select oc.obj_name obj_child,
       ec.obj_child child_id,
       c.cal_objid obj_id, c.obj_name, c.obj_type, c.obj_title, c.description,
       op.obj_name obj_parent,
       ep.obj_parent parent_id
  from object_list c,  
  cal_erd ec,
  object_list oc,
  cal_erd ep ,
  object_list op
  where ec.obj_parent(+) = c.cal_objid  -- if object is no parent still get an empty row
  and   ec.obj_child  = oc.cal_objid(+) -- if no child relation found stil get an empty row to get empty child-data
  and   ep.obj_child(+)  = c.cal_objid  -- if object is not a child still get an empty row
  and   ep.obj_parent = op.cal_objid(+) -- if no parent relation found stil get an empty row to get empty parent-data
)
returning value in IDE
BUT when i put same sql in to create record group am geting this error
error am geting in form builder when creating record group
am in oracle form 11gR2
chalie001Asked:
Who is Participating?
 
flow01Connect With a Mentor Commented:
Good memory slightwv : Deleting the comments works .
And changing   --comment1   to /* comment1 */  also.
0
 
slightwv (䄆 Netminder) Commented:
Haven't used Forms for many years.  Try deleting the comments.
0
 
chalie001Author Commented:
correct
0
 
flow01Commented:
Hello chalie, I think you should have given points to slightwv : he came with the right solution first.
My post was an addition making it possible to keep the comments
0
All Courses

From novice to tech pro — start learning today.