PL/SQL (MOSC)

MOSC Banner

Getting Subscript beyond count while calling procedure which accepts input as record type

edited Jun 14, 2020 12:59PM in PL/SQL (MOSC) 1 commentAnswered

I have to call a procedure that accepts input as record type. This record type has a table type for one column and i'm not able to make to call to this procedure using anonymous block. I'm getting the below error.

ORA-06533: Subscript beyond count

ORA-06512: at line

I'm attaching the sample package spec , body and anonymous block. Any help to resolve this issue will be greatly appreciated.

CREATE OR REPLACE PACKAGE TEST123 AS

TYPE number_arr IS TABLE OF number;

TYPE Record_Typ is RECORD(

Inventory_Item_Id               number_arr := number_arr());

PROCEDURE testing (

               p_rec            IN    TEST123.Record_Typ,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center