Inserting data into a table variable
719640Jan 18 2013 — edited Jan 18 2013Why does the following PL/SQL code say that the table or view doesn't exist:
DECLARE
type rectyp is record(CategId INT, intPath VARCHAR2(4000), CPropID INT, Property VARCHAR2(50), PropVal VARCHAR2(2000));
type tmplUpgradeTbl is table of rectyp;
tempTable tmplUpgradeTbl;
dgenTmplPropID INT;
BEGIN
INSERT INTO tempTable
select 23, '3,4,5', 41, 'Test', 'Test' from dual;
END;