RDBPROD: Problem With Blobs > 100000 Bytes via JDBC and OCI Services For Rdb

(Doc ID 343001.1)

Last updated on AUGUST 12, 2016

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.1.5.9.1 and later
Oracle JDBC for Rdb - Version 7.2 and later
Information in this document applies to any platform.



Symptoms

Insertion of Blobs using Java, Oracle JDBC and OCI Services occasionally fails. Some Blobs are inserted, some are not. In versions prior to 7.1.6.1, the following error may appear:

SQLException: I/O-Exception: End of TNS data channel

but this does not indicate failure reason. Using the SQLNET_DEBUG_FLAGS logical set to "H" in the process init file and ALTER SESSION LOG FULL; in the SQL init file for the OCI service displays the following error:

Client bind definition for item(1): 1
gtacvt.display_ora: entry
gtacvt.display_ora: Client data: column_name <2>
gtacvt.display_ora: Client data: type 24, length 100000, nul/ind 0, precision 0, scale 0
gtacvt.display_ora: exit
gtoall.gtoalls: SubFunction = Execute...
AL7 SubFunction: Execute
gtoexe.gtoexe: entry
gtoexe.gtoexe: Cursor number..........: 1
gtoexe.gtoexe: Number of iterations...: 1
gtoexe.gtoexe: Restart bind index.....: 0
gtoexe.gtoexer: entry
gtoexe.gtoexer: RXD received
gtoexe.gtoexer: reading bind var 1 into adr 2f28390
gtoexe.gtoexer: bind var has dty 1
gtoexe.gtoexer: working on bind var = 0
gtoexe.gtoexer: read string = 1

...

Client data for bind variable(1): 1
gtacvt.display_ora: entry
gtacvt.display_ora: Client data: column_name <2>
gtacvt.display_ora: Client data: type 24, length -257, nul/ind 0, precision 0,
scale 0
gtacvt.display_ora: exit
gtacvt.gtacvtfromora: entry
gtacvt.gtacvtfromora: Ora data type = 24
gtacvt.gtacvtfromora: suggested FDS data type = 509
** ERROR: gtmemma NO allocation for size <-257>
Assertion failed: "FALSE" in file NATCONN$SRC71:[CODE]GTME.C;1 at line 299.
%NONAME-E-NOMSG, Message number 00000002

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