Toad World® Forums

ERROR: This variable has a zero size

I cannot always reproduce this, but for some SUBTYPEs I get the following error (did not yet see it with 12.7).What does this error mean? The PL/SQL code looks fine and works as expected.

This is the error:
Found 'test_package.t_boolean_string': This variable has a zero size

This is the code:
CREATE OR REPLACE PACKAGE test_package AS
SUBTYPE t_boolean_string IS VARCHAR2(1);
END test_package;
/

DECLARE
v_test2 test_package.t_boolean_string;
BEGIN
v_test2 := 'Y';
END;

This has been fixed for first 12.9 beta.

On 10/29/2015 12:02 PM, Peter Lang wrote:

ERROR: This variable has a zero size

Thread created by Peter Lang
I cannot always reproduce this, but for some SUBTYPEs I get the following error (did not yet see it with 12.7).What does this error mean? The PL/SQL code looks fine and works as expected.

This is the error:

Found ‘test_package.t_boolean_string’: This variable has a zero size

This is the code:

CREATE OR REPLACE PACKAGE KLASSX.test_package AS

SUBTYPE t_boolean_string IS VARCHAR2(1);

END test_package;

/

DECLARE

v_test2 test_package.t_boolean_string;

BEGIN

v_test2 := ‘Y’;

END;

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.