Devart Forums

Our Kiosk program calls Oracle's procedure using by UniDAC Component.

There is a problem that sometimes Oracle's procedure is "Disable".

Whenever we have that problem, we should compile the Oracle's procedure to solve the problem.

I would like to know the reason of this problem.

Hello,

What do you mean by "procedure is "Disable""? Triggers and constraints can have the Enable/Disable status, and procedures and functions can have the VALID/INVALID status. Please specify the error message you get and the status of the procedure that is called at this moment. You can learn the current status using the following query:

select status
from user_objects
where object_name = 'PROCEDURE_NAME';

if the staus is INVALID, it looks like some modifications were made to it and it was not compiled after it.