Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    50

    Arrow Unanswered: pls-00414 column not found in table

    Hi All,
    I am trying to create a procedure which refers a column in a table.
    I am getting a strange error that "column does not exists" in the table.
    The column is present in this table and the spellings are absolutely correct.
    Can anyone suggest that what could be the cause.

    Thanks
    Ishan

  2. #2
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    Error Description:

    PLS-00414 no column 'string' in table
    Cause: A table name or alias was used to qualify a column reference, but the
    column was not found in that table. Either the column was never defined or the
    column name is misspelled.
    Action: Confirm that the column was defined and check the spelling of the
    column name.

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Is the table in your schema ??? If not, do you have select privs on the table ... are you referencing the table as schema_name.table_name or just table_name ... If so, is there a synonym and if so, is it current ???

    HTH
    Gregg

  4. #4
    Join Date
    Mar 2004
    Posts
    50
    I have been unable to make out what was causing the error as the spelling name, schema etc. everything was just fine.
    So, i dropped the column and then recreated it again.. and everything is working fine now.
    Seems more like a bug as there are many docs with similar problem on metalink.. and in all those cases, the problem was solved by such silly methods only like recreating the col or renaming the col etc.

    Thanks
    Ishan

Posting Permissions

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