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

找不到匯入的專案  請確認 <Import> 宣告中的路徑正確,而且檔案存在於磁碟上。

【Problem】  C:\inetpub\wwwroot\project\project.csproj : error  : 找不到匯入的專案 "C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v12.0\W...