Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting data into a table variable

719640Jan 18 2013 — edited Jan 18 2013
Why 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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2013
Added on Jan 18 2013
18 comments
51,098 views