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

Last updated on JULY 05, 2017

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

Symptoms

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

$ javac "DBTEST_CHAR4000.java"
$ 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(JNI.java:1221)
at rdb.JNI.PrepareStmt(Native Method)
at oracle.rdb.jdbc.common.AbstractNativeRdb.PrepareStmt(AbstractNativeRdb.java:297)
at oracle.rdb.jdbc.common.CommonRdbSynch.PrepareStmt(CommonRdbSynch.java:152)
at oracle.rdb.jdbc.common.Statement.prepareRdbStmt(Statement.java:3586)
at oracle.rdb.jdbc.common.Statement.executeQuery(Statement.java:2742)
at oracle.rdb.jdbc.common.Statement.executeQuery(Statement.java:627)
at DBTEST_CHAR4000.main(DBTEST_CHAR4000.java:15)
Forced disconnect due to process shutdown
$

 

Cause

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