Oracle-L: Embedded SQL problem

From: Martin, Alan (Contractor) (DLIS) <Alan.S.Martin_at_dla.mil>
Date: Fri, 10 Oct 2003 06:59:26 -0800
Message-ID: <F001.005D2B5B.20031010065926@fatcity.com>

We have a COBOL program using embedded SQL that is INSERTing thru the DRDA Gateway.

Any INSERT stmt succeeds via embedded SQL if the fields are all CHAR.
Any INSERT stmt succeeds via embedded SQL if any fields are VARCHAR2, so LONG AS THE LENGTH IS < 74 CHARACTERS. The INSERT fails (ORA-02055) if the VARCHAR2(1069) field contains 75 characters or more.

Note that any INSERT stmt succeeds via SQL*Plus if the fields are CHAR or VARCHAR2 (any length).

The problem appears to be with an embedded SQL buffer reaching the gateway when VARCHAR2s are involved. Is anyone aware of any OCI issues with 9.2.0.3? The gateway is 9.2.0.4. If anyone wishes to email me privately, I can send you our compiler/sql directive files, the source code (small test program) and table descriptions.

Thanx,
Alan Martin
DBA at Defense Logistics Info Service
alan.s.martin_at_dla.mil

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Martin, Alan (Contractor) (DLIS) INET: Alan.S.Martin_at_dla.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 10 2003 - 09:59:26 CDT