Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Unanswered: problems with updating

    Database Errors Occured
    UPDATE process_definition SET program_type_code='STORED PROC3',

    Error #-2147467259

    Error desc. -> [Microsoft][ODBC driver for Oracle][Oracle]ORA-01747: invalid user.table.column, table.column, or column specification
    i
    get this error when i try to update a record in the database. i know that my sql is correct and the table name and column is spelt correctly. does anyone know what i am doing wrong??
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: problems with updating

    Originally posted by DaGr8Anil
    Database Errors Occured
    UPDATE process_definition SET program_type_code='STORED PROC3',

    Error #-2147467259

    Error desc. -> [Microsoft][ODBC driver for Oracle][Oracle]ORA-01747: invalid user.table.column, table.column, or column specification
    i
    get this error when i try to update a record in the database. i know that my sql is correct and the table name and column is spelt correctly. does anyone know what i am doing wrong??
    Try specifying your schema name explicitly - the default schema may not be what you think it is...

    update schemaname.process_definition set ....
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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