Discussion

Default Date Issue with Oracle Db

Hi,

I have an external table(Oracle) - PART with a Database class mapping with a field - CREATED_DT. This is not a mandatory field. Everytime i do an Obj-Save to this class for a new record a default date of 31-DEC-69 is saved in the DB even though the value in the clipboard for this property is empty. Can you please let me know how to get around this issue

I tried setting property to null but it gives an error

Thanks
Shivaram

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

April 30, 2012 - 4:54pm

Another way to ask the same question - Is there a way to send NULL value to the Oracle DB field of property DATA in the DB through the OBJ_SAVE

June 20, 2016 - 10:06pm

Hi All,

We are seeing that some work object is capturing default value at UI 31 dec, 1969 while in pending status  . However at the clipboard correct value is captured.

Any input pls please what can be the issue.

 

Thanks