ORA-01036 illegal variable name/number

ORA-01036 illegal variable name/number

Postby JustinA » Wed 19 May 2010 00:41

I have tried almost everything under the sun to get an ext.js gridpanel to save correctly using the dotConnect tool and so far no luck. Everything I have tried gets the ORA-01036 error. What I can do is get the update statement to work if I manually enter the update value and the where clause value (to test the connection string and field names etc). But once I enter the field parameter values I get the ORA-01036 error message. For this test, the Oracle table only has the two fields. They are both Number fields. I tried the Original_ variable for the where clause variable and I get the same error message.

Here is the code:


UpdateCommand="UPDATE PROJECT_RESOURCE_TEST SET INTERNAL_EMPLOYEE_ID=:INTERNAL_EMPLOYEE_ID WHERE (PROJECT_ID=:PROJECT_ID)"
DataPagingMode="Auto"
SelectCommand="SELECT PROJECT_ID, INTERNAL_EMPLOYEE_ID FROM PROJECT_RESOURCE_TEST">









ID="Store2"
runat="server"
DataSourceID="orcTest"
UseIdConfirmation="true" >


















ID="Panel3"
runat="server"
Height="300"
Header="false">



ID="GridPanel2"
runat="server"
Title="Shows"
StoreID="Store2"
Border="false"
Icon="House" ClicksToEdit="1">

















runat="server"
StoreID="Store2"
PageSize="10"
DisplayInfo="false"
/>
















JustinA
 
Posts: 1
Joined: Wed 19 May 2010 00:31
Location: Pasadena

Postby Shalex » Fri 21 May 2010 16:39

Please use the Original_ prefix with the parameter that is used in the WHERE clause. Refer to http://www.devart.com/forums/viewtopic.php?t=14441.
1. Have you tried the latest 5.70.140 build of dotConnect for Oracle?
2. Are you using the Direct or OCI mode?

If the tips from the mentioned thread don't help, please send us a small test project with the DDL/DML script to reproduce the error in our environment. Also tell us your current versions of dotConnect for Oracle (x.xx.xx), Oracle Server, Oracle Client (if the OCI mode is used).
Shalex
Devart Team
 
Posts: 7284
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle