Results 1 to 2 of 2

Thread: Help Ora-00904

  1. #1
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Wink Unanswered: Help Ora-00904

    SQL> INSERT INTO student (student_id,pps_id,tutor_id,level_id,surname,foren ame,intial,title,gender,d
    ob,h_address,h_address2,h_city,h_postcode,h_teleph one,h_country,t_address,t_address2,t_city,t_postco
    de,t_telephone,m_telphone,email,next_of_kin,emeren cy_contact,application_date,been_accepted,graduate
    d,comments)
    2 VALUES(1,1,1,1,'russall','smith','n','mr','m',TO_D ATE('1-9-1985','DD-MM-YYYY'),'23 sun st','she
    lton','stoke-on-trent','st1 6bn','01782 852859','uk','17 Golden Hill Road','Golden Hill','Newcastle
    Under Lyme','ST4 3ED','01782 236589','07892 159852','russ232yahoo.com','jhon smith','01782 522285',T
    O_DATE('1-2-1999','DD-MM-YYYY'),'Y',null,null);
    INSERT INTO student (student_id,pps_id,tutor_id,level_id,surname,foren ame,intial,title,gender,dob,h_

    ERROR at line 1:
    ORA-00904: "BEEN_ACCEPTED": invalid identifier
    Any ideas about this error; I have changed the column name from accepted to been_accepted but it makes no difference.
    Last edited by rhs98; 03-12-03 at 16:10.

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    found this is due to nas's (user name: nahmed) spelling being shit.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •