如何通过 Oracle 应用程序中的表单个性化将发票编号限制为恰好 10 个字符
我的要求是，当发票草稿获得批准后，在发布块中启用发布按钮，我们可以输入发票编号。我需要将发票号码限制为恰好等于 10 位数字。如果用户输入的发票编号小于或大于 10，我需要显示错误。一切工作正常，但问题是假设，例如，如果用户输入少于 10 个字符的发票号码并按确定，则会显示错误，并且如果用户在此之后单击取消按钮。释放块已关闭，发票状态更改为已释放，发票编号将是用户给出的编号，但我的要求是假设用户在按确定取消 > 按钮，发票状态不应更改为已发布。
我正在使用when-validate-record触发器来释放块，并在条件下检查invoice_number的长度是否为10并基于显示错误。
My requirement is when the draft invoice is approved release button is enabled in release block we can enter invoice number. I need to restrict the invoice number exactly equal to 10 digits. If the user enters invoice number less than or greater than 10 I need to show error. Every thing is working fine but the problem is suppose for example if user enters invoice number less than 10 characters and presses ok error is shown and if user clicks cancel button after that. The release block is closed and the invoice status is changed to released and invoice number will be the number which is given by user, but my requirement is suppose user clicks cancel after pressing ok button the invoice status should not change to released.
I am using when-validate-record trigger for release block and in condition checking whether length of invoice_number is 10 and based on that showing error.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论