can you default this last field to zero if it is a null value in your SQL?
If you can do this, then it seems like that would fix the issue.
You have posted this question within the Getting Started (MOSC) space, which is not designated for any product questions. This space is for community members to ask questions about the My Oracle Support Community platform and find available resources pertaining to this community (from a functionality standpoint). Please review this resource in order to better understand the community structure and find the most appropriate space to post your question in: How to Find the Right Space in Which to Post Your Product Question.
Then, you will want to move this post to a specific product subspace that most closely aligns with your question. To move your post, simply click the "move" button located on the right side of this post, listed under "Actions".
Also, please go ahead and Update Your Community Display Name and Avatar! If you update your display name to something more unique, than others will be able to more easily identify you in the community (and not have to depend on your default user ID number).
My Oracle Support Community Administrator
Thanks for your guidance. i will move the card to right space.
Sure thing, 3682593! It does look like this post has been moved to the Integration - Adapters subspace, which resides in the Oracle Developer Community. Therefore, this post no longer lives in the My Oracle Support Community. If this is in fact the correct subspace to move this post to, it can certainly remain within this community. But, I did want to make you aware in case you meant to keep it within the My Oracle Support Community in a specific product subspace (see How to Find the Right Space in Which to Post Your Product Question, where we show you how to view all product subspaces within MOSC).
Also, please be sure to Update Your Community Display Name and Avatar!