Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h9AHBW617009 for ; Fri, 10 Oct 2003 12:11:32 -0500 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h9AHBVc17002 for ; Fri, 10 Oct 2003 12:11:31 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h9AE0SV03031 for oracle-l@orafaq.net; Fri, 10 Oct 2003 07:00:28 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D2B5B; Fri, 10 Oct 2003 06:59:26 -0800 Message-ID: Date: Fri, 10 Oct 2003 06:59:26 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Martin, Alan (Contractor) (DLIS)" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Martin, Alan (Contractor) (DLIS)" Subject: Embedded SQL problem Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C38F36.3BAB3DB0" ------_=_NextPart_001_01C38F36.3BAB3DB0 Content-Type: text/plain 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@dla.mil ------_=_NextPart_001_01C38F36.3BAB3DB0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable Embedded SQL problem

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@dla.mil

------_=_NextPart_001_01C38F36.3BAB3DB0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Martin, Alan (Contractor) (DLIS) INET: Alan.S.Martin@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@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).