ora-00972 identifier is too long oracle 10g

c# asp.net oracle gridview sqldatasource
Frank picture Frank · May 7, 2010 · Viewed 9.4k times · Source

I am getting the error mentioned in the title.

I am using a 36 charecter ID. This error is only thrown In my sqldatasource in my asp.net webform. It is not a problem when I perform updates in Oracle sql developer .

How can I fix this?

Answer

Srinivas Reddy Thatiparthy picture Srinivas Reddy Thatiparthy · May 7, 2010

Oracle supports an identifier with at most 30 characters and your identifier length 36 is greater than that.so make it 30 character in length.

see this link

Related questions

The provider is not compatible with the version of Oracle client

I'm trying to use the Oracle ODP.NET 11g (11.1.0.6.20) Instant Client on my ASP.net project as a Data Provider but when I run the aspx page I get a "The provider is not compatible with the version of Oracle …

Read More
How to fix "The provider is not compatible with the version of Oracle client"?

We're using the Oracle.DataAccess.dll assembly version 2.102.2.20 (32 bit). I deployed our Web API application to IIS and tried openning and closing a connection: private static void CheckConnectionUsingOracleClient(string connection) { var logger = DiContainer.Resolve<ILogger>(); try { logger.LogInfo("…

Read More
Handle NULL values when reading through OracleDataReader?

I'm working on my first ASP.Net application, and seem to be hitting a lot of hurdles (background primarily in WinForms with a recent MVC5 project under my belt). I am successfully making my DB connection using OracleCommand and executing …

Read More