Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    5

    Unanswered: ORA-00907: missing right parenthesis

    Hi, I am struggling with this error.
    My query works fine until I add the "Create View" code.
    Can anyone help me out. I have not much idea what more to try.
    The editor I'm using is TOAD 7.6.0.11.
    Thanks, HN.

    CREATE OR REPLACE FORCE VIEW ABCD.EFGH
    (b.BASE_NAME, a.ONE_LINE_ADDRESS)
    AS
    SELECT b.base_name, a.one_line_address
    FROM bases b, sites s, addr_link al, addresses a
    WHERE b.base_id = s.base_id(+)
    AND s.site_id = al.entity_id(+)
    AND al.address_id = a.address_id(+)
    AND b.base_id NOT IN (
    SELECT b.base_id
    FROM bases b,
    current_service cs,
    people p,
    in_places ip,
    ev_occurrs eo
    WHERE b.base_id = cs.base_id
    AND cs.emp_id = p.person_id
    AND p.person_id = ip.applic_id
    AND ip.course_id = eo.course_id
    AND eo.train_unit_id = 3);

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Try removing the alias references on the column definitions:

    <snip>
    CREATE OR REPLACE FORCE VIEW ABCD.EFGH
    (BASE_NAME, ONE_LINE_ADDRESS)
    AS
    SELECT b.base_name, a.one_line_address
    </snip>

    Should work fine after you do that.

    JoeB

  3. #3
    Join Date
    Apr 2004
    Posts
    5

    Thumbs up

    Can't believe I missed that... It's been a long day!
    Thanks

    HN

  4. #4
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    No problem. Having another set of eyes look at something is always helpful.

    Hope your day is better...

    JoeB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •