Toad World® Forums

ORA-12899: value too large for column "SYS"."QUEST_SL_TEMP_EXPLAIN1"."OBJECT_NAME" (actual: 31, maximum: 30)

SQL Optimizer: Version 9.3.4 x64
Oracle client: 19.3 x64
Oracle DB: 12.2.1 x64

The Parser did not identify the text as a valid SQL statement.

SELECT ROWID,
hum_category_num,
To_char(sys_creation_date,'YYYYMMDDHH24MISS'),
To_char(sys_update_date,'YYYYMMDDHH24MISS'),
operator_id,
application_id,
dl_service_code,
dl_update_stamp,
account_type,
credit_class,
avg_turnover_amt,
eu_avg_turnover_amt,
boni_score,
num_of_subscribers,
hum_category_priority,
hum_path_code,
multiben_indicator,
payment_method,
bank_indicator,
bi_month_factor
FROM MOBREFREAD1.hum_category hc
WHERE hc.account_type IN (:b40,'')
AND ( hc.credit_class = :b41
OR hc.credit_class = '
' )
AND hc.multiben_indicator IN (:b42,'')
AND hc.payment_method IN (:b43,'
')
AND hc.bank_indicator IN (:b44,'')
AND Decode(:b45,'E',hc.eu_avg_turnover_amt,hc.avg_turnover_amt) = Decode(:b45,'E',:b47,:b48)
AND hc.boni_score = ANY (SELECT Min(hc11.boni_score)
FROM MOBREFREAD1.hum_category hc11
WHERE hc11.account_type IN (:b40,'
')
AND hc11.credit_class IN (:b41,'')
AND hc.multiben_indicator IN (:b42,'
')
AND hc.payment_method IN (:b43,'')
AND hc.bank_indicator IN (:b44,'
')
AND hc11.boni_score >= :b54
AND hum_category_num >= -99E124)
AND hc.num_of_subscribers = (SELECT Min(hc12.num_of_subscribers)
FROM MOBREFREAD1.hum_category hc12
WHERE hc12.account_type IN (:b40,'')
AND hc12.credit_class IN (:b41,'
')
AND hc.multiben_indicator IN (:b42,'')
AND hc.payment_method IN (:b43,'
')
AND hc.bank_indicator IN (:b44,'*')
AND hc12.num_of_subscribers >= :b60)
ORDER BY hc.hum_category_priority DESC

ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SYS"."QUEST_SL_TEMP_EXPLAIN1"."OBJECT_NAME" (actual: 31, maximum: 30)

Invalid SQL statement.
Verify that you have selected the right schema.
Only one SQL statement can be optimized in this window.
To analyze PL/SQL code or multiple SQL statements use the Scan SQL.