ORA-01036: illegal variable name/number

[bin zhang]

Hi everyone;
        My radgrid bind sqldatasource. and My sqldatasource connect Oracle 10 database.    I want radgrid autoupdate. so I config the sqldatasource updatecommand and UpdateParameters. but when i edit the radgrid row. i appear a error: ORA-01036: illegal variable name/number
    my updatecommand like this   " update siteannvavle set a=:a,b=:b where c=:c"
 <UpdateParameters>
  </UpdateParameters>

 what's wrong?    did radgrid suport oracle 10g?

[Lenny_shp]

I had to define the columns as in this example.

http://www.telerik.com/help/aspnet-ajax/grdautomaticdatasourceoperations.html

[bin zhang]

My code is this. please tell me what's wrong with it? "illegal variable name/number"

<telerik:RadGrid ID="RadGrid1"  runat="server" AllowAutomaticUpdates="True"
                AllowPaging="True" AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1"
                GridLines="None">
<HeaderContextMenu EnableAutoScroll="True"></HeaderContextMenu>

<MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
    <Columns>
        <telerik:GridBoundColumn DataField="PIPOREXPLOR" HeaderText="PIPOREXPLOR"
            SortExpression="PIPOREXPLOR" UniqueName="PIPOREXPLOR">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="LINELOOPNAME" HeaderText="LINELOOPNAME"
            SortExpression="LINELOOPNAME" UniqueName="LINELOOPNAME">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="SITETYPE" HeaderText="SITETYPE"
            SortExpression="SITETYPE" UniqueName="SITETYPE">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="SITEORVALVENAME"
            HeaderText="SITEORVALVENAME" SortExpression="SITEORVALVENAME"
            UniqueName="SITEORVALVENAME">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="REMARKS" HeaderText="REMARKS"
            SortExpression="REMARKS" UniqueName="REMARKS">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="FIELDSNAME" HeaderText="FIELDSNAME"
            SortExpression="FIELDSNAME" UniqueName="FIELDSNAME">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="BELONGFIELDCODE"
            HeaderText="BELONGFIELDCODE" SortExpression="BELONGFIELDCODE"
            UniqueName="BELONGFIELDCODE">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="EVENTID" HeaderText="EVENTID"
            SortExpression="EVENTID" UniqueName="EVENTID">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ORDERCODE" DataType="System.Decimal"
            HeaderText="ORDERCODE" SortExpression="ORDERCODE" UniqueName="ORDERCODE">
        </telerik:GridBoundColumn>
    </Columns>
</MasterTableView>
            </telerik:RadGrid>
        </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:APDMConnectString %>"
            ProviderName="<%$ ConnectionStrings:APDMConnectString.ProviderName %>"
             ConflictDetection="OverwriteChanges"
            SelectCommand="SELECT &quot;PIPOREXPLOR&quot;, &quot;LINELOOPNAME&quot;, &quot;SITETYPE&quot;, &quot;SITEORVALVENAME&quot;, &quot;REMARKS&quot;, &quot;FIELDSNAME&quot;, &quot;BELONGFIELDCODE&quot;, &quot;EVENTID&quot;, &quot;ORDERCODE&quot; FROM &quot;SITEANDVALVE&quot;"
            UpdateCommand="UPDATE SITEANDVALVE SET PIPOREXPLOR = :PIPOREXPLOR, LINELOOPNAME = :LINELOOPNAME, SITEORVALVENAME = :SITEORVALVENAME, SITETYPE = :SITETYPE, REMARKS = :REMARKS, ORDERCODE = :ORDERCODE, FIELDSNAME = :FIELDSNAME WHERE (EVENTID = :EVENTID)">
            <UpdateParameters>
                <asp:Parameter Name="PIPOREXPLOR" Type="String" />
                <asp:Parameter Name="LINELOOPNAME" Type="String" />
                <asp:Parameter Name="SITEORVALVENAME" Type="String" />
                <asp:Parameter Name="SITETYPE" Type="String" />
                <asp:Parameter Name="REMARKS" Type="String" />
                <asp:Parameter Name="ORDERCODE" Type="Double" />
                <asp:Parameter Name="FIELDSNAME" Type="String" />
                <asp:Parameter Name="EVENTID" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>

[Yavor]

Hi bin zhang,

I reviewed the code, and the setup looks correct. If the issue persists, you can open a formal support ticket, and send us a small working project, demonstrating your setup. We will debug it locally, and advise you further.

Sincerely yours,
Yavor
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.