By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

Error 503 Server Temporarily Unavailable while executing plsql procedure in mod_plsql

P: n/a
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 =
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.