Look at the value of timestampStr to see if it is a valid date and time.
You are using a cb for time and may be it is not sending the correct string.
"scott johnson" <[EMAIL PROTECTED]> wrote:
>
>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"
>
>I assumed that ND was doing the to_date conversions. Apparently, I am wrong.
>Anyone conquered this CSpdatetime/Oracle issue?
>
>
>Code example:
>....
>
>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]
