Oracle Stored Procedure won't Run in Ignition

I am trying to run an Oracle stored procedure that is used in our production database to populate information on a visual factory screen. The Ignition access to the database is "read-only" due to some regulatory reasons and the DBA has granted the system "Execute" privilege's. I can run the query in SQL Developer under the same login with out issue.

Query:
DECLARE
pcurCoaterStatus SYS_REFCURSOR;

BEGIN
CHAMPS.DISPLAY.Get_Coater_Status (pcurCoaterStatus);
END;

Error received
Error running query: DECLARE pcurCoaterStatus SYS_REFCURSOR; BEGIN CHAMPS.DISPLAY.Get_Coater_Status (pcurCoaterStatus); END Cannot run this function when in read-only mode.

Any ideas would be great,
Thanks,

Your designer is in Read Only Mode. :wink:

2 Likes

Thanks, been chasing so many issues with the setup of connections that one didn't cross my mind.