How to update null value for an date column by using StoreProcedure from Spotfire

[Anil Avula]

Hi All,

I have a requirement to update the Date column to Null, based on a condition. i am trying to do it by using a Storedprocedure and calling it from Spotfire. If i run the procedure manually, it is executing sucessfully. the same procedure if i call from Spotfire, it is throwing an error as invalid month.

I am working on Spotfire 10.3.1 version.

I have attached the files for reference.

Please someone can advice on this one.

Thanks,

Anil

[Shashank Gurnalkar]

Instead of using '08/05/2020', can you try to use TO_DATE('2020/05/08', 'yyyy/mm/dd') as mentioned in the below thread:

https://www.techonthenet.com/oracle/functions/to_date.php

Also, refer to this to know more about why ORA-01843 occurs:

http://www.dba-oracle.com/t_ora_01843_not_a_valid_month.htm

[Anil Avula]

Thanks for the reply. it worked.

 

cheers

 

Anil