Identifier too long

[shashikanth69]

Hello,
when i try to execute the code it says,
ORA-00972: identifier is too long at adapter1.Fill(Ora_Dataset)

Sub BindGrid()
sSql=”Select * from Audit_Exceptions where Audit_ID=’”+ sauditid +”’ and TO_CHAR(Audit_Date,’MM/DD/YYYY’)= ‘”+sauditdate +”’ and Exception_Status=’”+ exceptionStatus+”’”
 
adapter1=New OracleDataAdapter(sSql,Ora_Conn)
adapter1.Fill(Ora_DataSet )
grid.DataSource=Ora_DataSet
grid.DataBind()
EndSub
 

When i selected the values in dropdownlist and click a button(which is that page below the dropdownlists) it shows me this error!

where auditdate has a DATE datatype
Auditid has Number datatype
Exceptionstatus has varchar datatype

When i keep break points on this code and whenevr the SQL stmt shows values in watch window i just copied the statement and executed in ORACLE
it gave me the result.
I tried every possibility,by creating a new table again and changing the column names.But still it didn't wrk!!!

[kenobewan]

Oracle Product Document Library (C) Oracle Corporation
Manual: Database Error Reference: A90202-02

ORA-00972 identifier is too long

Cause: The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames.

Action: Shorten the name to 30 characters or less.

Could also be your sql statement. HTH.