ORA-00972 "Identifier is too long"

From: Mats L <matsl_at_diamo.se>
Date: Tue, 24 Nov 1998 16:55:43 +0100
Message-ID: <73eknl$4mg1@Talisker.taide.net>

Hi there!

We are moving a SQLServer databas to Oracle 8. Field usg is declared as RAW(16).The same query in SQLServer works fine when usg is declared as varbinary(16).
Is it possible to use the hex value in Oracle ?.

select GroupName from usergroup where usg=0xb9089094fe05d2118d650060085299cb

returns error: ORA-00972 "Identifier is too long

This query works fine in Oracle but we don't need to change the applikation if it's possible to use hex value.

select GroupName from usergroup where usg='9089094fe05d2118d650060085299cb'

Any help would be appreciated.

Mats Received on Tue Nov 24 1998 - 09:55:43 CST