Skip to Main Content
Forums

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!

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

kenS

Replying to Joe's question in an attempt to get it visible on the Overview tab.  Seems like this is the only post displayed in Content tab that isn't also on the Overview tab.

Is this a forum defect?

Alex Keh-Oracle

This sounds like a known issue: Bug 17389314. Oracle Support is working to debug it.

1 person found this helpful
user12018946

Thank you for the Response.  So we need to determine what to communicate to our customers re: Oracle DB versions that work with our product.  To make this decision we need to know a few things:

1) Will a fix to this be in ODP?

2) Will that fix cover all Oracle DB versions 10.2 and later?

3) If so, is there a timeline when it might be available?

Thank you for your assistance!


Alex Keh-Oracle
Answer

Since the bug hasn't been diagnosed yet, I can't answer any of these question definitively. My expectation would be yes to the first two questions, but it really depends on the bug's root cause.

Marked as Answer by user12018946 · Sep 27 2020
Tedper-Oracle

Hi,

A fix is now available for Bug 17389314.  If you are licensed for support for ODP, and if the current version of ODP which you are running is within its period of Premier Support, then you may now file a service request, asking that the fix be backported to your current version.

Sincerely,

Ted

Oracle Support Services

1 - 5
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
927 views