ORA-01084(Invalid Argument in OCI Call) error
harrryDec 9 2009 — edited Dec 10 2009Hi
I am getting ORA-01084(invalid arguments in OCI call) error when I was trying to insert some records into a table through my .net application.
my query is as follows
INSERT INTO XYZ(ID,WIDTH) VALUES(:ID,:WIDTH) --where 'WIDTH' is an NUMBER(9) datatype.
the values for 'WIDTH' column are as follows
-1,-1,-1,-1,-2147483648(INT.MINVALUE---in .net),-1,..............
the query is executing/inserting successfully for first 4 vlaues of -1,when it comes to insert -2147483648 value it is throwing the mentioned error.
Query is inserting successfully if the values for 'WIDTH' column are as follows......
-2147483648,-2147483648, -2147483648, -2147483648,-1, -2147483648........
or
-1,-1,-1,-1,-1,9,-1,-1,......
it is throwing the ORA-01084 error only when the value -2147483648(int.min value in .net) comes after -1.
Stack Trace of the error:
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheckForOra1000Error)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheckForOra1000Error)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at InsertRow(IDbConnection connection, obj details) in C:\Oracle\InsertRow.cs:line 369
I'm using Oracle-11g DB and ODP.NET-11.1.0.7.10
any one help me please.
regards,
harry