OraFAQ Forum: Forms » i got an error as,Invalid reference to 'BLOCK

Home » Developer & Programmer » Forms » i got an error as,Invalid reference to 'BLOCK_NAME'

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

i got an error as,Invalid reference to 'BLOCK_NAME' [message #606880]

Thu, 30 January 2014 06:36

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

I wrote the Package code at the Program units

PACKAGE BODY BLOCKNAME IS
    Procedure Get_Org_Code(event varchar2) is
     Begin
      IF EVENT = 'POST_QUERY' then
--      	select organization_code
--      	  into :BlockName.Org_code
--        from org_organization_definitions
--        where organization_id = :BlockName.budget_entity;
--        exception
--        	when others then
--        	:BlockName.Org_code := null;
--	:BlockName.Org_code := '???';
	
	:HOPE_SALES_DATA.Org_code := null;(Blockname.item_name)

      end if;
    End;
END;

I called at the Database Block in the post-query