Forum OpenACS Q&A: Error when trying to login after upgrade

Hi, I just finished running all the scripts in order to upgrade oacs4.6.3 to 5.0.0 wiht oracle db and I get the following error when I try to view the first page of my installation:

[10/Sep/2004:10:05:13][31836.3076][-conn:upgrade::0] Error: nsoracle.c:3904:ora_tcl_command: error in `OCIStmtExecute ()': OR
A-04068: existing state of packages has been discarded
ORA-04063: package body "OPENACS5.ACS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

SQL:
  select site_node.url(node_id) as url, acs_object.name(object_id) as name
      from site_nodes
      where parent_id = site_node.node_id('/')
      and object_id is not null
      and acs_permission.permission_p(
          object_id,
          nvl(:user_id, !>>>!acs.magic_object_id('the_public')),
          'read') = 't'

[10/Sep/2004:10:05:13][31836.3076][-conn:upgrade::0] Error: GET http://129.219.88.130:8035/?
referred by ""
nsoracle.c:3904:ora_tcl_command: error in `OCIStmtExecute ()': ORA-04068: existing state of packages has been discarded
ORA-04063: package body "OPENACS5.ACS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

SQL:
  select site_node.url(node_id) as url, acs_object.name(object_id) as name
      from site_nodes
      where parent_id = site_node.node_id('/')
      and object_id is not null
      and acs_permission.permission_p(
          object_id,
          nvl(:user_id, !>>>!acs.magic_object_id('the_public')),
:


does anyone knows why?