Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01084(Invalid Argument in OCI Call) error

harrryDec 9 2009 — edited Dec 10 2009
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2010
Added on Dec 9 2009
7 comments
6,289 views