Invalid Field Size Error

Toad for Oracle
1

Hi,

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.

Thnaks,

Lee

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;

image

2

I can't reproduce this. Which version of Toad is it?

Edit: Nevermind. I can reproduce it when I uncheck this option. I'll fix it for next version. Thank you for reporting it.

image
image861×585 35.4 KB

3

Thanks vm John.

I thought I'd tried switching that option prior to this ticket!

Selecting the "Display large numbers in Scientific Notation" does allow the cursor to return as expected..

The version I'm using is :- 14.1.120.923

Regards,

Lee