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,