Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What could be causing this error......ORA-00904: : invalid identifier....??

512453Jul 1 2009 — edited Jul 1 2009
Hi,

My Webapp is returning this action error when a user click on a link:

Error occurred using:
SELECT ucp.*,
clp.forename, clp.surname, clp.suffix, clp.middle_name, clp.title, clp.investigator_flag,
clp.financial_disclosure_flag, cpr.role_desc
, FWD_JAVA.GET_SYSDATE() AS CURRENT_SYSDATE
FROM clinical_personnel clp, tu_clinical_personnel ucp
LEFT OUTER JOIN clinical_personnel_role cpr ON ucp.role_code = cpr.role_code
WHERE ucp.personnel_no = clp.personnel_no
AND ucp.trial_no = ?
AND ucp.country_code = ?
AND ucp.unit_no = ?
ORDER BY ucp.sequence_no

caused by:
ORA-00904: : invalid identifier



I'm stumped as to what maybe causing it because I know for certain that all column names are valid and correct. Any ideas??

Thanks!!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 29 2009
Added on Jul 1 2009
9 comments
711 views