I have the below test procedure that presents the below error.
I only see this issue if I'm returning numeric values.
Can someone shed some light on what's causing this issue when running.
The error pops up before I can open the cursor, and the cursor is not created.
CREATE OR REPLACE PROCEDURE SP_TEST ( feed OUT SYS_REFCURSOR ) AS BEGIN OPEN feed FOR SELECT 1 AS TEST_VALUE FROM DUAL; END SP_TEST;