I altered a table and added two columns. I ran reference type as tablename%rowtype in stored procedures. I got two error messages when I compiled the procedure: "PLS-00302: component 'NUMLABEL' must be declared" (this is for parameter declare) and "PLS-00417: unable to resolve 'NUMLABEL' as a column." This is for reference_rec.table%rowtype. I could not reference new column as reference_rec.newcolumn.
I checked table by desc command. Two new columns exist in the table in the database.
If I create a table with these new columns, it works fine. But I have the problem after adding new columns into the existing table.
This issue is only in Oracle8i. It works in Oracle9i and 10g. How do I find a solution? Thanks for any help!
CREATE OR REPLACE Procedure KK2 ( as_NumLabel in tableA.NUMLABEL%type, as_TypeLabel in tableA.TYPELABEL%type ) as BEGIN dbms_output.put_line('OK' ); dbms_output.put_line(as_NumLabel ); dbms_output.put_line(as_TypeLabel ); end kk2;
Dig Deeper on Oracle stored procedures
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.