Solved

Frm-10902 invalid sql query

Posted on 2014-12-03
4
514 Views
Last Modified: 2014-12-17
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
0
Comment
Question by:chalie001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40479610
Haven't used Forms for many years.  Try deleting the comments.
0
 
LVL 20

Accepted Solution

by:
flow01 earned 500 total points
ID: 40479658
Good memory slightwv : Deleting the comments works .
And changing   --comment1   to /* comment1 */  also.
0
 

Author Closing Comment

by:chalie001
ID: 40505289
correct
0
 
LVL 20

Expert Comment

by:flow01
ID: 40505319
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

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Verification of DataPump Export and Import 17 69
oracle forms question 22 48
Oracle programming for starter 14 37
Oracle perfomance issue. 4 24
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question