I'm trying to insert data in a table but I have got the error ORA-01400. If I open the package in pl/sql, right click the procedure and choose the option "Test", the registers are inserted perfectly, but if I try to run the package/procedure with an integration user (which has "Execute" grant) it runs but the insert fails and i get the ORA-01400.
Note 1: I'm not trying to insert null value in the column (varchar2(30) not nullable).
Note 2: All the other columns can be null.
I have been stuck in this problem for weeks (Help!!!!!), does anyone have any idea what could be happening?