Skip to Main Content

SQL & PL/SQL

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!

Update doesn't work.

elieldo martins6 days ago

Hello.

I have a procedure that updates a table with four fields.

Two of these fields are NUMBER.

When I run the procedure through SQL Developer, it works without problems.

But when it's called by a third-party application (the application inserts values ​​into a table that has a trigger that calls the procedure), the numeric values ​​aren't updated.

Does anyone know why the two numeric fields in the table aren't updated?

Thank you.

Comments
Post Details
Added 6 days ago
4 comments
89 views