Error 503 Server Temporarily Unavailable while executing plsql procedure in mod_plsql

[comavas]

This error occurs while I open the url to the plsql procudure:

http://192.168.0.154:7777/pls/chwd/chwebown.helloworld

PS: The compilation of this procedure was successful!

------------------------------------------------------------------------

The error_log contains the following line:

[Sat Feb 28 15:18:49 2004] [error] mod_plsql:
/pls/chwd/chwebown.helloworld HTTP-503 ORA-604

---------------------------------------------------------------------
The wdbsvr.app contains the following lines:

[DAD_chwd]
connect_string = WEBDB_LOCALHOST
password = *******
username = chwebown
;default_page =
;document_table =
;document_path =
;document_proc =
;upload_as_long_raw =
;upload_as_blob =
;name_prefix =
;always_describe =
;after_proc =
;before_proc =
reuse = Yes
;connmax =
;pathalias =
;pathaliasproc =
enablesso = No
;sncookiename =
stateful = STATELESS_RESET
;custom_auth =
response_array_size = 128
;exclusion_list =
;cgi_env_list =
bind_bucket_widths = 32,128,1450,2048,4000
bind_bucket_lengths = 4,20,100,400
;error_style =
;nls_lang =

[Frank van Bortel]

comavas wrote:

This error occurs while I open the url to the plsql procudure:

http://192.168.0.154:7777/pls/chwd/chwebown.helloworld

PS: The compilation of this procedure was successful!

------------------------------------------------------------------------

The error_log contains the following line:

[Sat Feb 28 15:18:49 2004] [error] mod_plsql:
/pls/chwd/chwebown.helloworld HTTP-503 ORA-604

---------------------------------------------------------------------
The wdbsvr.app contains the following lines:

[DAD_chwd]
connect_string = WEBDB_LOCALHOST
password = *******
username = chwebown
;default_page =
;document_table =
;document_path =
;document_proc =
;upload_as_long_raw =
;upload_as_blob =
;name_prefix =
;always_describe =
;after_proc =
;before_proc =
reuse = Yes
;connmax =
;pathalias =
;pathaliasproc =
enablesso = No
;sncookiename =
stateful = STATELESS_RESET
;custom_auth =
response_array_size = 128
;exclusion_list =
;cgi_env_list =
bind_bucket_widths = 32,128,1450,2048,4000
bind_bucket_lengths = 4,20,100,400
;error_style =
;nls_lang =

ORA-604: Check your db logs!

Also, your user is chwebown, is your procedure packaged in
a package chwebown, too? You call chwebown.helloworld; if
helloworld is a (stand alone) procedure, there is no
need to prefix. If it is a packaged procedure, prefix with
the package name. But only then
--

Regards,
Frank van Bortel