Oracle Sql Error 904 Sqlstate 42000
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or sql error: 904, sqlstate: 42000 hibernate posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Sql Error 904 Sqlstate 42000 Ora-00904 Invalid Identifier
Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only sql error 1064 sqlstate 42000 hibernate takes a minute: Sign up SQL Error: 904, SQLState: 42000 ORA-00904: : invalid identifier up vote 0 down vote favorite Can below scenario of duplicate alias lead to an error when executed from JDBC or hibernate: SQL Error: 904, SQLState:
Java Sql Sqlsyntaxerrorexception Ora 00904 Invalid Identifier
42000 ORA-00904: : invalid identifier select * From table_master VW LEFT OUTER JOIN TABLE(test_func(1, 300)) vw ON VW.table_key = vw.function_key Facing this in production only. It works fine in test environment. sql oracle hibernate jdbc share|improve this question edited Sep 2 at 17:19 Daniel 1,4983824 asked Sep 2 at 17:16 sam_evang 64 2 you're assigning the vw alias twice? That can't be right. –sstan Sep 2 at 17:19 ya.. it works as oracle don't complain. But in production ora-00904 invalid identifier hibernate not sure why it gives error. Can some oracle schemas be case seneitive. –sam_evang Sep 2 at 17:20 1 I agree that I can get the query to work in Oracle 12c myself (maybe production is on a different version of Oracle?). But in my opinion, that should be the bug. I don't think the query should be considered valid, it's ambiguous. If I were you, I would just assign 2 distinct aliases, which is really the only sane thing to do here, and try again with that. –sstan Sep 2 at 17:29 What are the exact versions of the two servers (edit your question and add the output of select * from v$version) –a_horse_with_no_name Sep 2 at 18:05 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Browse other questions tagged sql oracle hibernate jdbc or ask your own question. asked 1 month ago viewed 354 times Related 1Intermittent ORA-00904: : invalid identifier0SQL Error: ORA-00904: : invalid identifier in CREATE AS SELECT1ORA-00904: Invalid identifier when using dbms_random.value0SQL: ORA-00904: invalid identifier0ErrorC
here for a quick overview of the site Help
Sql Error: 932, Sqlstate: 42000
Center Detailed answers to any questions you might have
Sql Error 942 Sqlstate 42000 Hibernate
Meta Discuss the workings and policies of this site About Us Learn more about Stack ora-00932: inconsistent datatypes: expected number got binary Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask http://stackoverflow.com/questions/39297701/sql-error-904-sqlstate-42000-ora-00904-invalid-identifier Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-00904: invalid identifier up vote 24 down vote favorite 10 I tried to write the http://stackoverflow.com/questions/6027961/ora-00904-invalid-identifier following inner join query using an Oracle database: SELECT Employee.EMPLID as EmpID, Employee.FIRST_NAME AS Name, Team.DEPARTMENT_CODE AS TeamID, Team.Department_Name AS teamname FROM PS_TBL_EMPLOYEE_DETAILS Employee INNER JOIN PS_TBL_DEPARTMENT_DETAILS Team ON Team.DEPARTMENT_CODE = Employee.DEPTID That gives the below error: INNER JOIN PS_TBL_DEPARTMENT_DETAILS Team ON Team.DEPARTMENT_CODE = Employee.DEPTID * ERROR at line 4: ORA-00904: "TEAM"."DEPARTMENT_CODE": invalid identifier The DDL of one table is: CREATE TABLE "HRMS"."PS_TBL_DEPARTMENT_DETAILS" ( "Company Code" VARCHAR2(255), "Company Name" VARCHAR2(255), "Sector_Code" VARCHAR2(255), "Sector_Name" VARCHAR2(255), "Business_Unit_Code" VARCHAR2(255), "Business_Unit_Name" VARCHAR2(255), "Department_Code" VARCHAR2(255), "Department_Name" VARCHAR2(255), "HR_ORG_ID" VARCHAR2(255), "HR_ORG_Name" VARCHAR2(255), "Cost_Center_Number" VARCHAR2(255), " " VARCHAR2(255) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS sql database oracle ora-00904 share|improve this question edited Jun 1 at 19:45 Abhishek 871822 asked May 17 '11 at 8:05 Navaneethan 53551028 Are you sure the column name Department_Code is spelled correctly? –Fabrizio D'
Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.