-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|