Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Application throws ORA-01036: illegal variable name/number exception

Description

Hi ,

I am working with Nhibernate3.0 and .net framework 3.5.

I have upgraded it from NHibernate 1.2.With previous version it was working fine.

I have also upgraded my ODP.net to 11g as it is required for call stored procedure from my application.

But suddenly after working for sometime perfectly, application throws " ORA-01036: illegal variable name/number" exception.

Application starts throwing following exception while any insertion and updation.

This problem persist until I restart my application

Following is my Database configuration file:

2011-07-22 11:27:41,222 [Worker] [0] ERROR NHibernate.AdoNet.AbstractBatcher [(null)]<(null)> - Could not execute command: INSERT INTO AUDIT_TRAIL ( AUT_ENT_LV_ID, AUT_REF_ENT_LV_ID, AUDIT_ACTION_LV_ID, AUAC_ID , AUT_OLD_VALUE, AUT_NEW_VALUE, LAST_UPDATED_DATE, LAST_UPDATED_BY, AUT_UPDATED_BY_TYPE_LV_ID, SEC_ID, AUT_SEC_NAME, AC_ID, AUT_ENTITY_ID, AUT_PROCESS_ID, AUT_ENTITY_NAME, AUT_AC_NAME, aut_sub_entity_name, AUT_ID) VALUES (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
Oracle.DataAccess.Client.OracleException ORA-01036: illegal variable name/number at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)
2011-07-22 11:27:41,222 [Worker] [0] ERROR NHibernate.Util.ADOExceptionReporter [(null)]<(null)> - ORA-01036: illegal variable name/number

Environment

None

Attachments

1

Activity

Show:

Oskar Berggren 
April 15, 2012 at 2:40 PM

There is talk of bugs in older ODP.Net causing this, but the version mentioned by the reporter is supposed to not have the bug.
https://forums.oracle.com/forums/thread.jspa?threadID=717515

We do have several failures with the ORA-01036 message for the NHibernate test suite. These go away when I run them with a recent ODP.Net version.

Fabio Maulo 
July 30, 2011 at 12:36 PM

Dear Anupan,
You can make your supposition without problems.

Anupam Mishra 
July 29, 2011 at 1:13 PM

Dear Fabio, It is happening in insert but at runtime.If it is a problem with mapping it would have given an issue at first insert only. But after working for a day or two it throws exception. And the only solution is to restart application. And from the same mapping fecth is working even when I am facing problem with data insert. So it can't be a problem with mapping. That's why I raised a bug with Critical priority because it is forcing my application to restart.

Thanks and Regards
Anupam Mishra
Tata Consultancy Services
DLF Akruti Info Park,
PN 28,
Rajiv Gandhi Infotech Park Hinjewadi, PHASE II
Pune - 411057,Maharashtra
India
Mailto: anupam3.m@tcs.com
Website: http://www.tcs.com

Fabio Maulo 
July 29, 2011 at 12:33 PM

If it happen in insert you have a wrong mapping.
Which is?

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created July 26, 2011 at 5:53 AM
Updated September 9, 2014 at 1:00 PM
Who's Looking?