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!

compilation errors

765707May 20 2010 — edited May 20 2010
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2010
Added on May 20 2010
7 comments
2,181 views