Forum Discussion

DMc-Cabe's avatar
DMc-Cabe
Occasional Contributor
11 years ago

[Resolved] Receving invalid Orcale DB response

Hi there

I'm receiving what looks like an invalid Oracle DB response when running a select using a property value

select * from Oracle.TableName where identifiername = ${propertyPass#Name}

the error I get back is as follows :

Thu Jan 08 17:33:14 GMT 2015:ERROR:java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

However, if I run the same request without the property value it works fine

select * from Oracle.TableName where identifiername = 'My identifier value'

The same type of request works fine for MySQL, is there an different way to pass properties for Oracle DB queries?
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    11 years ago
    Hi,

    I believe this is some sort of syntax issue with Oracle compared to MySQL. Can you check that the property expansion you are doing contains single quotes around the string?


    Regards,
    Marcus
    SmartBear Support
  • DMc-Cabe's avatar
    DMc-Cabe
    Occasional Contributor
    11 years ago
    SmartBear Support wrote:
    Hi,

    I believe this is some sort of syntax issue with Oracle compared to MySQL. Can you check that the property expansion you are doing contains single quotes around the string?


    Regards,
    Marcus
    SmartBear Support


    Perfect, that has resolved the issue