when a execute this SQL query, i have this error
'invalid request BLR at offset 100.
Implementation limit exceeded.
block size exceeds implementation restriction.'
and It works on SQLSERVER !

here is my query

"SELECT DISTINCT SCHEMAGAMME.*, GAMME_CODE, LIBGAMME.LIBDATA_LIB
GAMME_LIB, LIBGAMME2.LIBDATA_LIB GAMME_DESC, RUBGAMME_CODE,
LIBRUBGAMME.LIBDATA_LIB RUBGAMME_LIB, SCHEMA_FICHIER,
LIBSCHEMA.LIBDATA_LIB SCHEMA_LIB, LIBFAMILLE.LIBDATA_LIB FAMILLE_LIB
FROM SCHEMAGAMME, FAMILLE, GAMME, RUBGAMME, UNSCHEMA, LIBDATA
LIBGAMME, LIBDATA LIBGAMME2, LIBDATA LIBRUBGAMME, LIBDATA
LIBSCHEMA,LIBDATA LIBFAMILLE
WHERE SCHEMAGAMME_GAMME_ID = GAMME_ID
AND LIBGAMME.LIBDATA_LNG_CODE='FR'
AND LIBGAMME.LIBDATA_TABLE = 'GAMME'
AND LIBGAMME.LIBDATA_CHAMP = 'GAMME_LIB'
AND LIBGAMME.LIBDATA_TABLE_ID = GAMME_ID
AND LIBGAMME2.LIBDATA_LNG_CODE='FR'
AND LIBGAMME2.LIBDATA_TABLE = 'GAMME'
AND LIBGAMME2.LIBDATA_CHAMP = 'GAMME_DESC'
AND LIBGAMME2.LIBDATA_TABLE_ID = GAMME_ID
AND SCHEMAGAMME_RUBGAMME_ID = RUBGAMME_ID
AND LIBRUBGAMME.LIBDATA_LNG_CODE='FR'
AND LIBRUBGAMME.LIBDATA_TABLE = 'RUBGAMME'
AND LIBRUBGAMME.LIBDATA_CHAMP = 'RUBGAMME_LIB'
AND LIBRUBGAMME.LIBDATA_TABLE_ID = RUBGAMME_ID
AND SCHEMAGAMME.SCHEMAGAMME_ID = 671
AND SCHEMA_CODE=SCHEMAGAMME_SCHEMA_CODE
AND LIBSCHEMA.LIBDATA_LNG_CODE='FR'
AND LIBSCHEMA.LIBDATA_TABLE = 'SCHEMA'
AND LIBSCHEMA.LIBDATA_CHAMP = 'SCHEMA_LIB'
AND LIBSCHEMA.LIBDATA_TABLE_ID = SCHEMA_ID
AND FAMILLE_ID = GAMME_FAMILLE_ID
AND LIBFAMILLE.LIBDATA_LNG_CODE='FR'
AND LIBFAMILLE.LIBDATA_TABLE = 'FAMILLE'
AND LIBFAMILLE.LIBDATA_CHAMP = 'FAMILLE_LIB'
AND LIBFAMILLE.LIBDATA_TABLE_ID = FAMILLE_ID
ORDER BY SCHEMAGAMME_ORDRE"


Can you help me ?

davyd rey