have you created the package in the database - yes or no
SQL scripts sitting on your laptop are irrelevant
yes.i have moved on by created the package and the body. and a new user with erarch.
now.. i have warning :compilation error ..
it complained certain table and view not exist, i dont think i can ignore the warning..
well not really, you need to make sure the tables exist