Invalid Field Name ORA-00904:Invalid Column Name
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Invalid Field Name ORA-00904:Invalid Column Name

  1. #1
    Join Date
    Aug 2001
    Location
    uae
    Posts
    21
    !!Urgent Help !!


    I am using an application with Delphi Front end and Oracle 8i back end.
    I am gettig an error when i click on some particular form, and this error is random. I am able to work on this form , but sometimes i am getting this error. i am using BDE5.1 and i updated the patch also.

    error is :

    INVALID FIELD NAME
    ORA-00904:INVALID COLUMN NAME


    THIS ERROR IS COMMING IN A BOX WITH AND 'OK' BUTTON

    I need urgent help reagrding this

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    well, it's quite explicit ... if you get this error, it's because you try to use an invalid column name (in a select, insert, update or delete statement)

  3. #3
    Join Date
    Aug 2001
    Location
    uae
    Posts
    21
    Thanks for the reply.

    In this case the error is random. i am using the same form every time. sometimes i get this error , most of the time i am able to work. And this is when i click on the form. If i am accessing an invalid field, it should come everytime.

    waiting for the reply

  4. #4
    Join Date
    Apr 2001
    Posts
    55
    I have seen this error occur sometimes depending on what type of user log ins to the application. Basically is one of the columns on the form generated by using a procedure of some sort. When I got the error one of the columns ws filled in by running a stored procedure when the form opened. The stored procedure is run as follows for example. cas.getid. Now when this process was run as the database owner it worked. However when this was run as a user it gave me th invalid column name error. It interpreted this procedure as a column in a table with CAS being the table name and GETID being the column.

    The fix is that you put the symbol ~ infront of the proc name so that it reads as ~cas.getid , for example. This will then distinguish the procedure as a proc rather than a table column.

    Hope this helps

Posting Permissions

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



Click Here to Expand Forum to Full Width