Java.Sql.Sqlexception: 'Length' Is Not A Recognized Built-In Function Name. (Doc ID 1373147.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 and later
Information in this document applies to any platform.

Goal

The goal of this article provides the solution for the error java.sql.SQLException: 'length' is not a recognized built-in function name.

SYSUSER - 190469-21-1 2011-10-27 22:13:17,085 [http-6500-1] DEBUG (org.hibernate.SQL) select field__1_.FLD_NAME as FLD1_554_, field__1_.VERSION as VERSION554_, field__1_.DATA_TYPE_FLG as DATA3_554_, field__1_.EXT_DATA_TYPE_FLG as EXT4_554_, field__1_.SIGNED_SW as SIGNED5_554_, field__1_.FLD_PRECISION as FLD6_554_, field__1_.FLD_SCALE as FLD7_554_, field__1_.FLD_VAL_CB as FLD8_554_, field__1_.WORK_FLD_SW as WORK9_554_, field__1_.OWNER_FLG as OWNER10_554_, field__1_.OBJ_PROPERTY_NAME as OBJ11_554_, field__1_.BASE_FLD_NAME as BASE12_554_, field__1_.FLD_NAME as col_0_0_, length(field_lang0_.DESCRLONG) as col_1_0_ from CI_MD_FLD_L field_lang0_, CI_MD_FLD field__1_ where field_lang0_.FLD_NAME=field__1_.FLD_NAME and ((field_lang0_.FLD_NAME in('DE_SHOW_XML_LBL' , 'DE_PRINT_LBL' , 'DE_CLEAR_FLTR_LBL' , 'DE_EXP_TO_EXCEL_LBL' , 'DE_SHOW_SQL_LBL'))and(field_lang0_.LANGUAGE_CD=? ))
SYSUSER - 190469-23-1 2011-10-27 22:13:17,085 [http-6500-2] DEBUG (hibernate.type.StringType) binding 'ENG' to parameter: 1
SYSUSER - 190469-21-1 2011-10-27 22:13:17,085 [http-6500-1] DEBUG (hibernate.type.StringType) binding 'ENG' to parameter: 1
SYSUSER - 190469-23-1 2011-10-27 22:13:17,101 [http-6500-2] WARN (hibernate.util.JDBCExceptionReporter) SQL Error: 195, SQLState: 42000
SYSUSER - 190469-23-1 2011-10-27 22:13:17,101 [http-6500-2] ERROR (hibernate.util.JDBCExceptionReporter) 'length' is not a recognized built-in function name.
SYSUSER - 190469-21-1 2011-10-27 22:13:17,101 [http-6500-1] WARN (hibernate.util.JDBCExceptionReporter) SQL Error: 195, SQLState: 42000
SYSUSER - 190469-23-1 2011-10-27 22:13:17,101 [http-6500-2] ERROR (support.impl.QueryImpl) Error getting list on hibernate query ' from Field_Language fl WHERE fl.id.parent in ('DE_SHOW_XML_LBL', 'DE_PRINT_LBL', 'DE_CLEAR_FLTR_LBL', 'DE_EXP_TO_EXCEL_LBL', 'DE_SHOW_SQL_LBL') and fl.id.language = :langId '
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108)
at org.hibernate.loader.Loader.list(Loader.java:2103)
at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:912)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms