when i try to execute the below code it says,
ORA-00972: identifier is too long
at the lineadapter1.Fill(Ora_Dataset)
sSql=Select * from Audit_Exceptions where Audit_ID=+ sauditid + and TO_CHAR(Audit_Date,MM/DD/YYYY)= +sauditdate + and Exception_Status=+ exceptionStatus+
I checked the name of the table and Columns , but all are less than 30 characters
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 SQL Plus
it gave me the result rows.
I tried every possibility,by creating a new table again and changing the column names.But still it didn't wrk!!!