Devart Forums

intrad80

Thank you!!. Works great with Original_ID_EMP_0000 parameter

!

intrad80

Getting same error with gridview, any ideas?

Code: Select all

intrad80

Thank you but I have the same error with the 2 parameters. My table have only 2 columns ID_EMP_0000 and E_PD_SURNAME and I put the 2 parameters in the UPDATECOMMAND.

Create table:

CREATE TABLE CEINSA.EMP_2008 (
E_PD_SURNAME CHAR(20),
ID_EMP_0000 LONG)
TABLESPACE CEINSAEX
STORAGE (
INITIAL 64K
MAXEXTENTS UNLIMITED
)
LOGGING;

Code: Select all

'>

intrad80

Hello, I recieve this exception when i try to update a row with a formview control. The oracle column E_PD_SURNAME is char(20). I use an oracle 10g database and vs2008 3.5 framework and oracle provider Version=5.0.22.0

Exception

Code: Select all

Devart.Data.Oracle.OracleException was unhandled by user code
  Code=1036
  ErrorCode=-2147467259
  Message="ORA-01036 illegal variable name/number"
  Offset=0
  Source="Devart.Data.Oracle"
  StackTrace:
       en Devart.Data.Oracle.s.a(aq[] A_0, Byte[] A_1)
       en Devart.Data.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
       en Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
       en Devart.Data.Oracle.Web.OracleDataSource.a.a(CommandBehavior A_0)
       en System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
       en Devart.Data.Oracle.OracleCommand.ExecuteReader(CommandBehavior behavior)
       en Devart.Data.Oracle.Web.OracleDataSource.a.a(CommandBehavior A_0)
       en System.Data.Common.DbCommand.ExecuteReader()
       en Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
       en System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation)
       en System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues)
       en System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback)
       en System.Web.UI.WebControls.FormView.HandleUpdate(String commandArg, Boolean causesValidation)
       en System.Web.UI.WebControls.FormView.UpdateItem(Boolean causesValidation)
       en _Default.Button2_Click(Object sender, EventArgs e) en E:\ceinsaDE\ASP.NET\GDCEcinfa\Default.aspx.vb:línea 13
       en System.Web.UI.WebControls.Button.OnClick(EventArgs e)
       en System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
       en System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
       en System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       en System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
       en System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  InnerException:

.ASPX Code

Code: Select all

'>

intrad80

Hello, does the OraDirect.NET 3.5 or 4 provider fully support Oracle 9.2 RAC installations?.
We use this connectionstring:

mStrConnection = "Data Source=" & mSqlIP & ";" & _
"User Id=" & mUserBD & ";" & _
"Sid=" & mNameBD & ";" & _
"Password=" & mPwdBD & ";" & _
"Port=" & mSqlPort & ";" & _
"Direct=true"

Thanks.

Devart Forums

Search found 5 matches

ORA-01036 illegal variable name/number

ORACLE RAC 9.2