PLS-00103: Encountered the symbol - URGENT HELP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: PLS-00103: Encountered the symbol - URGENT HELP

  1. #1
    Join Date
    Nov 2001
    Posts
    55
    Please help me urgent . . .
    OPEN ocurASSAY FOR
    SELECT DISTINCT a.*,
    (SELECT last FROM PERSON p, ASSAY_PERSON ap
    WHERE p.person_id = ap.PERSON_ID
    AND ap.ASSAY_ID = a.ASSAY_ID AND ap.ASSAY_ROLE = 'Definer' AND ROWNUM = 1) AS last,
    (SELECT familiar_name FROM PERSON p, ASSAY_PERSON ap
    WHERE p.person_id = ap.PERSON_ID
    AND ap.ASSAY_ID = a.ASSAY_ID AND ap.ASSAY_ROLE = 'Definer' AND ROWNUM = 1) AS familiar_name
    FROM ASSAY a,
    ASSAY_PERSON b
    WHERE a.ASSAY_ID = b.ASSAY_ID
    AND (a.ASSAY_STATUS = aviASSAY_STATUS OR aviASSAY_STATUS IS NULL)
    AND (b.person_id = aniPERSON_ID OR aniPERSON_ID IS NULL)
    AND (b.ASSAY_ROLE = aviASSAY_ROLE OR aviASSAY_ROLE IS NULL);

    ThanX in advance

    Raj

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Error: PLS-103
    Text: Encountered the symbol "%s" when expecting one of the following:
    ---------------------------------------------------------------------------
    Cause: This error message is from the parser. It found a token
    (language element) that is inappropriate in this context.
    Action: Check previous tokens as well as the one given in the
    error message. The line and column numbers given in the error
    message refer to the end of the faulty language construct.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2001
    Posts
    55
    The error is coming at the subselect part, it means I cannot opne a cursor with the select stmt?

    error is at

    (SELECT last FROM PERSON p, ASSAY_PERSON ap
    WHERE p.person_id = ap.PERSON_ID
    AND ap.ASSAY_ID = a.ASSAY_ID AND ap.ASSAY_ROLE = 'Definer' AND ROWNUM = 1) AS last,


    Raj

Posting Permissions

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


Click Here to Expand Forum to Full Width