Re: problems with updating
Try specifying your schema name explicitly - the default schema may not be what you think it is...
Originally posted by DaGr8Anil
Database Errors Occured
UPDATE process_definition SET program_type_code='STORED PROC3',
Error desc. -> [Microsoft][ODBC driver for Oracle][Oracle]ORA-01747: invalid user.table.column, table.column, or column specification
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??
update schemaname.process_definition set ....
"It does not work" is not a valid problem statement.