search cancel

ORA-12899: value too large for column "API_OTK "."OAUTH_CLIENT_KEY"."CALLBACK" (current: 3482, maximum: 2048


Article ID: 239823


Updated On:


CA API Gateway


After the our investigation on the following case provided no KB or similar doc from any of our sources (Communities, Tech Docs, etc) we are raising the case so you can provide the necessary help.

  • Environment – Production
  • Product version - 10.0

Bellow is the initial error :

"When writing trying to write a record to the GW database, we are getting the following error:

2022-04-11T11:26:45.486-0300 WARNING 815 com.l7tech.server.jdbc.JdbcQueryingManagerImpl: Failed to perform querying since [l7tech][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "API_OTK "."OAUTH_CLIENT_KEY"."CALLBACK" (current: 3482, maximum: 2048)

I would like to know if increasing the column in question from 2048 to 3500 or 4000 will not cause problems in the data recovery process at another time.



Release :

Component :


I have confirmed today , the supported method is to change the size ,

mysql> ALTER TABLE otk_db.oauth_client_key MODIFY COLUMN callback VARCHAR(4096);

however do not supported to change the data type from VARCHAR to CLOB