My Oracle Support Banner

DB2 For ISeries And AS/400]STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX (Doc ID 2392074.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Database Gateway for DRDA - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

You are using Oracle Database Gateway for DRDA (DG4DRDA) 12.1.0.2 and encounter the following error:

hgopoer, line 240: got native error -180 and sqlstate HY000; message follows...
[Oracle][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX. 17 *N {HY000,NativeErr = -180}
Exiting hgopoer, rc=0 at 2016/06/02-16:11:40
hgoexec, line 302: calling SQLExecute got sqlstate HY000
nrows:0
Exiting hgoexec, rc=28500 at 2016/06/02-16:11:40 with error ptr FILE:hgoexec.c LINE:302 ID:Executing SQL stmt

Changes

 You may using a procedure that has a date and time formatted as follows:

 

x_datefrom := to_char(rec_confirm.date_from, 'yyyymmddHH24MiSS');
x_dateto := to_char(rec_confirm.date_to, 'yyyymmddHH24MiSS');
x_stamp := to_char(rec_confirm.stamp, 'yyyymmddHH24MiSS');

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.