java.sql.SQLDataException: ORA-01843: not a valid month ORA-06512: at line 1

Question

Hi All, 
 I am getting the following error when I am trying to insert into Oracle data base from Stored procedure. from Appian can we send date and time to SP ? because in oracle DB they are not storing timestamp with included GMT but Appian will send timestamp including GMT.

aloks0189 · Answer

You have 2 options to resolve this issue: 
 
1. You'll need to split the data into 2 columns, one a datetime, and the other holding the timezone information. And pass the first part in string format to stored procedure where stored procedure will convert this varchar2 data into timestamp format using TO_TIMESTAMP() function of Oracle. 
 
2. Pass Appian function now() result in the form of string/varchar2 as an input to the stored procedure where your procedure need to convert this back into timestamp format using TO_TIMESTAMP() function where you need to mention your timestamp in varchar2 format as it's first parameter and the format of timestamp as it's 2nd parameter 
 
Hope this will help you

aloks0189 · Answer

You have 2 options to resolve this issue: 
 
1. You'll need to split the data into 2 columns, one a datetime, and the other holding the timezone information. And pass the first part in string format to stored procedure where stored procedure will convert this varchar2 data into timestamp format using TO_TIMESTAMP() function of Oracle. 
 
2. Pass Appian function now() result in the form of string/varchar2 as an input to the stored procedure where your procedure need to convert this back into timestamp format using TO_TIMESTAMP() function where you need to mention your timestamp in varchar2 format as it's first parameter and the format of timestamp as it's 2nd parameter 
 
Hope this will help you