ORA-01036: illegal variable name/number on Batch edit mode

[Allen]

I'm using Batch edit mode.  My insert command is very simple:
InsertCommand="INSERT INTO "WFM_CAT_RECURRENCE_DT" VALUES (:DIVISION, :DISTRICT, :LOCATION, :FROM_YEAR, :FROM_WEEK, :TO_YEAR, :TO_WEEK, :USERID, :USERNAME, SYSDATE)" but  it gives me an error:ORA-01036: illegal variable name/number.  Can anyone help?
My aspx is as follow:
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Copy_To_Maintenance.aspx.vb"
    Inherits="Copy_To_Maintenance" %>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContentPlaceHolder" Runat="Server">

    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        <Scripts>
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />
        </Scripts>
    </telerik:RadScriptManager>
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" />
   
<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True"
            CellSpacing="0" DataSourceID="OracleDatabase1" GridLines="None"
            AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
            AllowAutomaticUpdates="True" AutoGenerateColumns="False"
            AllowFilteringByColumn="True" Width="1250px">
            <mastertableview
                datakeynames="USERID,USERNAME,CREATE_DATE"
                datasourceid="OracleDatabase1" commanditemdisplay="TopAndBottom"
                EditMode="Batch" BatchEditingSettings-EditType="Cell"
                autogeneratecolumns="False" >
                <RowIndicatorColumn Visible="False">
                </RowIndicatorColumn>
                <ExpandCollapseColumn Created="True">
                </ExpandCollapseColumn>
                <Columns>
                    <telerik:GridBoundColumn DataField="DIVISION"
                        FilterControlAltText="Filter DIVISION column" HeaderText="DIVISION"
                        ReadOnly="False" SortExpression="DIVISION" UniqueName="DIVISION" AllowFiltering="True">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="DISTRICT"
                        FilterControlAltText="Filter DISTRICT column" HeaderText="DISTRICT"
                        SortExpression="DISTRICT" UniqueName="DISTRICT" ReadOnly="False">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="LOCATION"
                        FilterControlAltText="Filter LOCATION column" HeaderText="LOCATION"
                        SortExpression="LOCATION" UniqueName="LOCATION" ReadOnly="False">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="FROM_YEAR" DataType="System.Decimal"
                        FilterControlAltText="Filter FROM_YEAR column" HeaderText="FROM_YEAR"
                        SortExpression="FROM_YEAR" UniqueName="FROM_YEAR">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="FROM_WEEK" DataType="System.Decimal"
                        FilterControlAltText="Filter FROM_WEEK column" HeaderText="FROM_WEEK"
                        SortExpression="FROM_WEEK" UniqueName="FROM_WEEK">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="TO_YEAR" DataType="System.Decimal"
                        FilterControlAltText="Filter TO_YEAR column" HeaderText="TO_YEAR"
                        SortExpression="TO_YEAR" UniqueName="TO_YEAR">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="TO_WEEK" DataType="System.Decimal"
                        FilterControlAltText="Filter TO_WEEK column" HeaderText="TO_WEEK"
                        SortExpression="TO_WEEK" UniqueName="TO_WEEK">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="USERID"
                        FilterControlAltText="Filter USERID column" HeaderText="USERID"
                        SortExpression="USERID" UniqueName="USERID" ReadOnly="True">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="USERNAME"
                        FilterControlAltText="Filter USERNAME column" HeaderText="USERNAME"
                        SortExpression="USERNAME" UniqueName="USERNAME" ReadOnly="True">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="CREATE_DATE" DataType="System.DateTime"
                        FilterControlAltText="Filter CREATE_DATE column" HeaderText="CREATE_DATE"
                        SortExpression="CREATE_DATE" UniqueName="CREATE_DATE" ReadOnly="True">
                    </telerik:GridBoundColumn>
                    <telerik:GridButtonColumn Text="Delete" CommandName="Delete" ButtonType="ImageButton" />
                </Columns>
            </mastertableview>
           
        </telerik:RadGrid>
        <telerik:RadWindowManager ID="RadWindowManager1" runat="server">
        </telerik:RadWindowManager>
   
    <asp:SqlDataSource ID="OracleDatabase1" runat="server"
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            DeleteCommand="DELETE FROM &quot;WFM_CAT_RECURRENCE_DT&quot; WHERE &quot;DIVISION&quot; = :DIVISION AND &quot;DISTRICT&quot; = :DISTRICT AND &quot;LOCATION&quot; = :LOCATION AND &quot;FROM_YEAR&quot; = :FROM_YEAR AND &quot;FROM_WEEK&quot; = :FROM_WEEK AND &quot;TO_YEAR&quot; = :TO_YEAR AND &quot;TO_WEEK&quot; = :TO_WEEK AND &quot;USERID&quot; = :USERID AND &quot;USERNAME&quot; = :USERNAME AND &quot;CREATE_DATE&quot; = :CREATE_DATE"
            InsertCommand="INSERT INTO &quot;WFM_CAT_RECURRENCE_DT&quot; VALUES (:DIVISION, :DISTRICT, :LOCATION, :FROM_YEAR, :FROM_WEEK, :TO_YEAR, :TO_WEEK, :USERID, :USERNAME, SYSDATE)"
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
            SelectCommand="SELECT &quot;DIVISION&quot;, &quot;DISTRICT&quot;, &quot;LOCATION&quot;, &quot;FROM_YEAR&quot;, &quot;FROM_WEEK&quot;, &quot;TO_YEAR&quot;, &quot;TO_WEEK&quot;, &quot;USERID&quot;, &quot;USERNAME&quot;, &quot;CREATE_DATE&quot; FROM &quot;WFM_CAT_RECURRENCE_DT&quot;"
           
            UpdateCommand="UPDATE &quot;WFM_CAT_RECURRENCE_DT&quot; SET &quot;LOCATION&quot; = :LOCATION, &quot;FROM_YEAR&quot; = :FROM_YEAR, &quot;FROM_WEEK&quot; = :FROM_WEEK, &quot;TO_YEAR&quot; = :TO_YEAR, &quot;TO_WEEK&quot; = :TO_WEEK, &quot;USERID&quot; = 'ID', &quot;USERNAME&quot; = 'NAME', &quot;CREATE_DATE&quot; = SYSDATE WHERE &quot;DIVISION&quot; = :DIVISION AND &quot;DISTRICT&quot; = :DISTRICT AND &quot;LOCATION&quot; = :LOCATION AND &quot;USERID&quot; = :USERID AND &quot;USERNAME&quot; = :USERNAME AND &quot;CREATE_DATE&quot; = :CREATE_DATE">

            <DeleteParameters>
                <asp:Parameter Name="DIVISION" Type="String" />
                <asp:Parameter Name="DISTRICT" Type="String" />
                <asp:Parameter Name="LOCATION" Type="String" />
                <asp:Parameter Name="FROM_YEAR" Type="Decimal" />
                <asp:Parameter Name="FROM_WEEK" Type="Decimal" />
                <asp:Parameter Name="TO_YEAR" Type="Decimal" />
                <asp:Parameter Name="TO_WEEK" Type="Decimal" />
                <asp:Parameter Name="USERID" Type="String" />
                <asp:Parameter Name="USERNAME" Type="String" />
                <asp:Parameter Name="CREATE_DATE" Type="DateTime" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="DIVISION" Type="String" />
                <asp:Parameter Name="DISTRICT" Type="String" />
                <asp:Parameter Name="LOCATION" Type="String" />
                <asp:Parameter Name="FROM_YEAR" Type="Decimal" />
                <asp:Parameter Name="FROM_WEEK" Type="Decimal" />
                <asp:Parameter Name="TO_YEAR" Type="Decimal" />
                <asp:Parameter Name="TO_WEEK" Type="Decimal" />
                <asp:Parameter Name="USERID" Type="String" />
                <asp:Parameter Name="USERNAME" Type="String" />
                <asp:Parameter Name="CREATE_DATE" Type="DateTime" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="DIVISION" Type="String" />
                <asp:Parameter Name="DISTRICT" Type="String" />
                <asp:Parameter Name="LOCATION" Type="String" />
                <asp:Parameter Name="FROM_YEAR" Type="Decimal" />
                <asp:Parameter Name="FROM_WEEK" Type="Decimal" />
                <asp:Parameter Name="TO_YEAR" Type="Decimal" />
                <asp:Parameter Name="TO_WEEK" Type="Decimal" />
                <asp:Parameter Name="USERID" Type="String" />
                <asp:Parameter Name="USERNAME" Type="String" />
                <asp:Parameter Name="CREATE_DATE" Type="DateTime" />
            </InsertParameters>
        </asp:SqlDataSource>
</asp:Content>

 

 

 

 

 

 

 

[Angel Petrov]

Hi Allen,

It looks like there is a syntax error in the InsertCommand. I would like to ask you is Oracle being used? Please remove the semicolons from the command text and test whether this resolves the problem.

Regards,
Angel Petrov
Telerik

[Allen]

If I change the SYSDATE to :CREATE_DATE, it works just fine.  Why?

[Angel Petrov]

Hi Allen,

This is due to the fact that data field which is used is named CREATE_DATE and the insert parameter defined is also named the same way. Moreover there is no insert parameter named SYSDATE and this is causing the problem.

Regards,
Angel Petrov
Telerik