ORA-00911: invalid character, visual studio 2010 using aspxg

Question

ive当y尝试在我的Oracle数据库中插入一行时，会出现此错误。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。

听说这可能是"；在SQL说明的结尾，但没有"；在此SQL句子中，这是带有SQL指令的代码，用于插入，更新等...

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
           ConflictDetection="CompareAllValues" 
           ConnectionString="<%$ ConnectionStrings:ConnectionStringora %>" 
           DeleteCommand="DELETE FROM &quot;MAQUINA&quot; WHERE &quot;PATENTE&quot; = ? AND &quot;MARCA&quot; = ? AND &quot;MODELO&quot; = ? AND &quot;AÑO&quot; = ? AND &quot;FECHA_ADQUISICION&quot; = ? AND &quot;ESTADO&quot; = ? AND &quot;IDCONDUCTOR&quot; = ? AND &quot;IDMANTENCION&quot; = ?" 
           InsertCommand="INSERT INTO &quot;MAQUINA&quot; (&quot;PATENTE&quot;, &quot;MARCA&quot;, &quot;MODELO&quot;, &quot;AÑO&quot;, &quot;FECHA_ADQUISICION&quot;, &quot;ESTADO&quot;, &quot;IDCONDUCTOR&quot;, &quot;IDMANTENCION&quot;) VALUES (?, ?, ?, ?, ?, ?, ?, ?)" 
           OldValuesParameterFormatString="original_{0}" 
           ProviderName="<%$ ConnectionStrings:ConnectionStringora.ProviderName %>" 
           SelectCommand="SELECT &quot;PATENTE&quot;, &quot;MARCA&quot;, &quot;MODELO&quot;, &quot;AÑO&quot;, &quot;FECHA_ADQUISICION&quot;, &quot;ESTADO&quot;, &quot;IDCONDUCTOR&quot;, &quot;IDMANTENCION&quot; FROM &quot;MAQUINA&quot;" 
           UpdateCommand="UPDATE &quot;MAQUINA&quot; SET &quot;MARCA&quot; = ?, &quot;MODELO&quot; = ?, &quot;AÑO&quot; = ?, &quot;FECHA_ADQUISICION&quot; = ?, &quot;ESTADO&quot; = ?, &quot;IDCONDUCTOR&quot; = ?, &quot;IDMANTENCION&quot; = ? WHERE &quot;PATENTE&quot; = ? AND &quot;MARCA&quot; = ? AND &quot;MODELO&quot; = ? AND &quot;AÑO&quot; = ? AND &quot;FECHA_ADQUISICION&quot; = ? AND &quot;ESTADO&quot; = ? AND &quot;IDCONDUCTOR&quot; = ? AND &quot;IDMANTENCION&quot; = ?">

我认为可能导致此问题的另一件事是日期字段（fecha_adquicion）.. aspxgridview使用格式DD-MM-yyy，我不知道Oracle是否接受了这一点，因为当我尝试从"服务器资源管理器"（您可以观看数据库的那一部分）我对日期有问题，我得到了ora-01843不是有效的月份"错误"。.所以我无法从那里插入。

帮助！

Answer 1

"是您的问题。用单引号（'）替换它，它将起作用。

*更新：与其进行硬编码SQL查询，不如将其从后面的代码传递。它将起作用。*