ORA-00904: Invalid identifier

    The identifier (column name, function, ...) entered is invalid or unknown.




    It can be an unknown function, a column name that does not belong to a table, an invalid table alias, ...


    eg:

    SQL> select unknown_function from dual;
    select unknown_function from dual
           *
    ERROR at line 1:
    ORA-00904: "UNKNOWN_FUNCTION": invalid identifier

    SQL> select X1 from dual;
    select X1 from dual
           *
    ERROR at line 1:
    ORA-00904: "X1": invalid identifier


    SQL> select x.DUMMY from dual a;
    select x.DUMMY from dual a
           *
    ERROR at line 1:
    ORA-00904: "X"."DUMMY": invalid identifier


Adverteren bij Daisycon
Forum Messages
23-FEB-2008 08:06:33ora-00904anuj kumar singh Reply
FULLPACKAGENAME."CONST_1_0_YEAR1":invalid identifier is the error given by toad...m not able to get the solution....i need help.
28-MAR-2008 15:52:59ORA-00904: : invalid identifiervijaya raju Reply
I have the following table and am trying to create a unique key... different from the
existing primary key.
The primary key is made up the first 4 columns in the table
(MDB_TRANS_VENDOR_NAME,MDB_TRANS_OPCO,MDB_TRANS_VENDOR_NUM,MDB_TRANS_FACILITY)

I'm getting the "ORA-00904: : invalid identifier" error when trying to add an additional unqiue key:

i.e
SQL> l
1 ALTER TABLE mdb_trnsact_temp
2 add CONSTRAINT UNIQUE_810 (MDB_TRANS_VENDOR_NAME,
3 MDB_TRANS_OPCO,
4 MDB_TRANS_VENDOR_NUM,
5 MDB_TRANS_FACILITY,
6* MDB_TRANS_810)
SQL> /
add CONSTRAINT UNIQUE_810 (MDB_TRANS_VENDOR_NAME,
*
ERROR at line 2:
ORA-00904: : invalid identifier

The column names are correct and datatypes are all correct... what's the problem here????
Thank you in advance!!!

SQL> desc mdb_trnsact_temp
Name Null? Type
----------------------------------------- -------- ----------------------------
MDB_TRANS_VENDOR_NAME NOT NULL VARCHAR2(30)
MDB_TRANS_OPCO NOT NULL VARCHAR2(10)
MDB_TRANS_VENDOR_NUM NOT NULL VARCHAR2(15)
MDB_TRANS_FACILITY NOT NULL VARCHAR2(10)
MDB_TRANS_VERSION VARCHAR2(15)
MDB_TRANS_810 NOT NULL VARCHAR2(1)
MDB_TRANS_820 NOT NULL VARCHAR2(1)
MDB_TRANS_835 NOT NULL VARCHAR2(1)
MDB_TRANS_850 NOT NULL VARCHAR2(1)
MDB_TRANS_852 NOT NULL VARCHAR2(1)
MDB_TRANS_855 NOT NULL VARCHAR2(1)
MDB_TRANS_875 NOT NULL VARCHAR2(1)
MDB_TRANS_880 NOT NULL VARCHAR2(1)
MDB_TRANS_204 NOT NULL VARCHAR2(1)
MDB_TRANS_990 NOT NULL VARCHAR2(1)
MDB_TRANS_CC_875_VEND VARCHAR2(15)
MDB_TRANS_CC_852_VEND VARCHAR2(15)
MDB_TRANS_COMMENT VARCHAR2(50)
MDB_TRANS_ALLITEM_875 VARCHAR2(1)
MDB_TRANS_ALLITEM_852 VARCHAR2(1)
MDB_TRANS_856 VARCHAR2(1)

: ->  28-MAR-2008 15:57:13Use create unique indexDbMotive Reply
You have to use a different statement to create a unique index.


create unique index UNIQUE_810
on mdb_trnsact_temp
(MDB_TRANS_VENDOR_NAME,
MDB_TRANS_OPCO,
MDB_TRANS_VENDOR_NUM,
MDB_TRANS_FACILITY,
MDB_TRANS_810
)



: ->  28-MAR-2008 16:04:28Thank you VERY MUCH for the QUICK reply/RESOLUTION !!! vijaya raju Reply
20-APR-2008 12:12:49Invalid identifierJaikishen Reply
Hi i am creating a university online web page. I am using Oracle 10g for the database and JavaEclipse for my html and servlets.
I created my table as follows:
create table student
(
stud_id varchar(10),
stud_name varchar(20),
stud_dept varchar(10),
stud_program varchar(30),
stud_pwd varchar(30),

constraint student_pk primary key(stud_id)
)

I have a html page which accepts the user name and password and passes it to the servlet. Here it accepts the username but it says
101
st001
java.sql.SQLException: ORA-00904: "STUD_PWD": invalid identifier

Could you please help me out??
Add your message for ORA-00904
Name:email:
Validation Code:mxbbv2dvb8oyrhn00
Enter Code above:
Title:
State your problem: