Forum Stats

  • 3,724,109 Users
  • 2,244,689 Discussions
  • 7,850,864 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

ORA-06533: Subscript beyond count

Lokesh A
Lokesh A Member Posts: 10 Red Ribbon

Hi,

DECLARE

TYPE EmpTabTyp IS TABLE OF orders%ROWTYPE;

emp_tab EmpTabTyp := EmpTabTyp(NULL);  --initialization

BEGIN

SELECT * INTO emp_tab(5)

FROM orders--;

WHERE order_id = 'o-001';

END;


Order table structure

ORDER_ID VARCHAR2(10 BYTE)

PROD_ID VARCHAR2(10 BYTE)

PRODUCT_CATEGORY VARCHAR2(50 BYTE)

ORDER_DATE DATE

QTY NUMBER(38,0)


I am filtering with single row only, ex- o-001 record but i am getting error

Tagged:

Best Answer

Answers

Sign In or Register to comment.