# Oracle Stored Procedure won't Run in Ignition

**URL:** <https://forum.inductiveautomation.com/t/oracle-stored-procedure-wont-run-in-ignition/70549>\
**Category:** Ignition\
**Tags:** perspective, ignition81\
**Created:** [March 2, 2023, 6:26pm UTC](https://forum.inductiveautomation.com/t/oracle-stored-procedure-wont-run-in-ignition/70549 "2023-03-02T18:26:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Becknell](https://avatars.discourse-cdn.com/v4/letter/d/f6c823/32.png) [@David\_Becknell](https://forum.inductiveautomation.com/u/David_Becknell)\
**Post date:** [March 2, 2023, 6:26pm UTC](https://forum.inductiveautomation.com/t/oracle-stored-procedure-wont-run-in-ignition/70549/1 "2023-03-02T18:26:58Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [March 2, 2023, 6:51pm UTC](https://forum.inductiveautomation.com/t/oracle-stored-procedure-wont-run-in-ignition/70549/2 "2023-03-02T18:51:41Z")

</div>

> [@David\_Becknell](#):
>
> 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.

Your designer is in Read Only Mode. 😉

---

<div class="post-metadata">

**Author:** ![David\_Becknell](https://avatars.discourse-cdn.com/v4/letter/d/f6c823/32.png) [@David\_Becknell](https://forum.inductiveautomation.com/u/David_Becknell)\
**Post date:** [March 2, 2023, 7:02pm UTC](https://forum.inductiveautomation.com/t/oracle-stored-procedure-wont-run-in-ignition/70549/3 "2023-03-02T19:02:38Z")

</div>

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