Home » Developer & Programmer » Forms » i got an error as,Invalid reference to 'BLOCK_NAME'
i got an error as,Invalid reference to 'BLOCK_NAME' [message #606880] Thu, 30 January 2014 06:36 Go to next message
mist598
Messages: 929
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
BLOCK_NAME.Get_Org_Code('POST_QUERY');


When i compile the code in the post-query , i got an error as,Invalid reference to 'BLOCK_NAME'
Re: i got an error as,Invalid reference to 'BLOCK_NAME' [message #606882 is a reply to message #606880] Thu, 30 January 2014 06:57 Go to previous messageGo to next message
cookiemonster
Messages: 10961
Registered: September 2008
Location: Rainy Manchester
Senior Member
[quote title=mist598 wrote on Thu, 30 January 2014 12:36]
PACKAGE BODY BLOCKNAME IS


BLOCK_NAME


They don't match.
Re: i got an error as,Invalid reference to 'BLOCK_NAME' [message #606883 is a reply to message #606882] Thu, 30 January 2014 07:06 Go to previous message
mist598
Messages: 929
Registered: February 2013
Location: Hyderabad
Senior Member
This is a silly mistake
Thanks a lot cookiemonster.. Smile
Previous Topic: Hide Current window
Next Topic: How to displayed only login form
Goto Forum:
  


Current Time: Thu Sep 18 10:54:42 CDT 2014

Total time taken to generate the page: 0.05777 seconds