Hi,
I have to perform insert,update and delete operations on Schema level PLSQL tables.
Following codes, i'm using:
----------------------------------------------------------
create or replace TYPE OBJ_SLAB_COTTON IS OBJECT(BRAND_CODE VARCHAR(4000),
SUPPLIER VARCHAR(4000),
DEPAT_CODE VARCHAR2(4000),
STYLE_CODE VARCHAR(4000),
COLOR_CODE VARCHAR(4000),
INTAKE_QTY NUMBER,
STOCK_QTY NUMBER,
SALES_QTY NUMBER,
COMP_QTY NUMBER,
RSP NUMBER,
WAC NUMBER,
FLEX_V_1 VARCHAR2(4000),
FLEX_V_2 VARCHAR2(4000),
FLEX_N_1 NUMBER,
FLEX_N_2 NUMBER
);
/
create or replace TYPE TAB_SLAB_COTTON IS TABLE OF OBJ_SLAB_COTTON;
/
DECLARE
LOC_SLAB_TAB TAB_SLAB_COTTON;
CURSOR C1 IS
SELECT OBJ_SLAB_COTTON (...) FROM <TABLE_NAME>;
BEGIN
OPEN C1;
FETCH BULK COLLECT INTO LOC_SLAB_TAB;
CLOSE C1;
UPDATE LOC_SLAB_TAB SET SUPPLIER ='est';
END;
/
Invalid table name error is coming while trying to update the LOC_SLAB_TAB table.
Kindly give me a solution.