compilation errors
765707May 20 2010 — edited May 20 2010I have a procedure which looks like this
CREATE OR REPLACE PROCEDURE ADDRESS_UPDATE_117418
(
p_stopdate IN PARTD.Household_address.hhold_addr_stop_date%type ,
p_startdate IN PARTD.Household_Address.HHOLD_ADDR_START_DATE%type ,
p_addressid IN PARTD.HOUSEHOLD_ADDRESS.HOUSEHOLD_ADDRESS_ID%type ) as ......
when I am compiling this I am getting an error which says "the identifier Household_address must be declared"
When I do a select * from or a DML on partd.Household_address table I wont get any error.
When I change the %type declaration to datatype like date , it gets compiled fine. I dont know where am I doing mistake.
Please help me. Thanks in advance