My Oracle Support Banner

RDBPROD: SQL-F-STRTOOBIG, String literal is too big (Doc ID 1118674.1)

Last updated on DECEMBER 23, 2019

Applies to:

Oracle JDBC for Rdb - Version 7.2 and later
Oracle ODBC Driver for Rdb - Version 3.0 and later
Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS Itanium
HP OpenVMS Alpha


Trying to insert more than 1024 characters into a char(4000) field using the native JDBC driver fails with an error.

$ javac ""
$ java "DBTEST_CHAR4000"
jdbc:rdbNative:$1$DGA15:[DB_ROOT]test_db_72.rdb is open
java.sql.SQLException: in <rdbjdbcsrv:prepare_stmt>
%SQL-F-STRTOOBIG, String literal is too big
at rdb.JNI.setSQLException(
at rdb.JNI.PrepareStmt(Native Method)
at oracle.rdb.jdbc.common.AbstractNativeRdb.PrepareStmt(
at oracle.rdb.jdbc.common.CommonRdbSynch.PrepareStmt(
at oracle.rdb.jdbc.common.Statement.prepareRdbStmt(
at oracle.rdb.jdbc.common.Statement.executeQuery(
at oracle.rdb.jdbc.common.Statement.executeQuery(
at DBTEST_CHAR4000.main(
Forced disconnect due to process shutdown



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.