Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

MOD function with embedded LOG function gives an incorrect result

User_8MZ3YJun 28 2022

MOD(LOG(2,4),1) = 1
How is this possible?

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production

Comments

InoL

I have a form region in my application
There is a whole application in your workspace. Where is the problem?

rgiljohann

The form is on page 3 called Audit. You can get there by clicking on the links on the report page to populate existing records which is how the end users will end up doing it.

image.png

InoL
Answer

If you run your page in debug mode you see weird things happening. Always run in debug mode if you don't know what is happening!
As far as I could see you had both a Submit default action and a Click DA on your Save button. I removed the DA, and now it works.

Marked as Answer by rgiljohann · Jan 5 2023
rgiljohann

You are awesome. Thank you. It is odd that having a DA causes it to fail, but I can worry about that some other time. Thanks again.

InoL

It is odd that having a DA causes it to fail
Not at all. Your button has the Submit action, and your DA had it too too. That caused a double submit, as you can see in the debug log if you put that DA back. That totally f*ed up the whole process. Debugging is the most important tool a developer can have!

1 - 5

Post Details

Added on Jun 28 2022
#bug, #function, #general-database-discussions, #sql
4 comments
198 views