Thursday, 15 October 2020

ORA-01747: invalid user.table.column, table.column, or column specification

 ORA-01747: invalid user.table.column, table.column, or column specification


於System.Data.OracleClient.OracleConnection.CheckError(OciError Handle errorHandle, Int32 rc)

於System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor & rowidDescriptor, ArrayList & resultParameterOrdinals)

【原因】SQL 的WHERE欄位沒有確認,例如少一個AND

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete

IIS HTTP Error 403.18

 HTTP Error 403.18 - Forbidden The specified request cannot be processed in the application pool that is configured for this resource on the...