Re: WebDB errors...(package has errors)

I missed the original post here. Have all your packages under the OAS_PUBLIC and WEBDB users compiled ok?

(select owner,object_name,object_type from dba_objects  where status='INVALID';)

When you installed WebDB did you include the lines OPEN_CURSORS=2000
MAX_ENABLED_ROLES=25
in your init<SID> file?

Jason.

On Tue, 14 Dec 1999 18:30:51 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>I tried reinstalling it, same problem
>
>
>14/Dec/1999:13:34:42
>
>ORA-04068: existing state of packages has been discarded
>ORA-04063: package body "WEBDB.WWV_LANGUAGE_UTILITY" has errors
>ORA-06508: PL/SQL: could not find program unit being called
>ORA-06512: at "WEBDB.WWV_GLOBAL", line 20
>ORA-06512: at "WEBDB.HOME", line 12
>ORA-06512: at line 1
>
> DAD name: WebDB
> PROCEDURE : WEBDB.home
> USER : webdb
> URL : http://sydney:8080/WebDB/?
> PARAMETERS :
> ===========
>
> ENVIRONMENT:
> ============
> SERVER_PORT=8080
> SERVER_SOFTWARE=Oracle WebDb Listener 2.0
> SERVER_NAME=sydney
> GATEWAY_INTERFACE=CGI/1.1
> SERVER_PROTOCOL=HTTP/1.0
> REMOTE_HOST=192.168.1.73
> REMOTE_ADDR=192.168.1.73
> REQUEST_METHOD=GET
> QUERY_STRING=
> SCRIPT_NAME=
> PATH_INFO=/WebDB/
> HTTP_CONNECTION=Keep-Alive
> HTTP_USER_AGENT=Mozilla/4.61 [en] (Win98; I)
> HTTP_HOST=192.168.1.45:8080
> HTTP_ACCEPT=image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
>image/png, */*
> HTTP_ACCEPT_ENCODING=gzip
> HTTP_ACCEPT_LANGUAGE=ru,en
> HTTP_ACCEPT_CHARSET=iso-8859-1,*,utf-8
> HTTP_AUTHORIZATION=Basic d2ViZGI6d2ViZGI=
>---------------
>Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
>AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Wed Dec 15 1999 - 11:45:10 CST