Having problems inserting a datetime value into an Oracle timestamp datatype.
Getting an Oracle error,
1830: date format picture ends before converting entire input string
Anyone conquered CSpdatetime coupled with Oracle?
...
CSpMultiSQL idpDO = (CSpMultiSQL) CSpider.getDataObject("idpAdmin");
CSpTransaction theTrans = new CSpTransaction();
..
String dateStr = getDisplayFieldValue("txStartDate").stringValue();
String timeStr = getDisplayFieldValue("cbStartTime").stringValue();
String timestampStr = new String(dateStr + " " + timeStr);
CSpDatetime theTS = new CSpDatetime();
try
{theTS = new CSpDatetime(timestampStr);}
catch (CSpDatetimeParsingException ex)
..
idpDO.setValue("LOAD_IDP_LOAD_DATE", theTS);
..
theTrans.addDataObject (idpDO
,idpDO.constructDefaultInsertDBRequest()
);
command = theTrans.execute();
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
