Re: PL/SQL web strange problem

"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message news:c3hc7b$878$1_at_news1.tilbu1.nb.home.nl...
> Holger Baer wrote:
>
> > Frank van Bortel wrote:
> >
> >> Holger Baer wrote:
> >>
> >>> Bob Le Brocq wrote:
> >>>
> > <snip>
> >
> >>
> >> I doubt it's apache, as the OP uses oas_public - that would be
> >
> >
> > I doubt that too, but from my limited experience with mod_plsql
> > if there was an error calling a stored procedure, I always found
> > an ORA-XXXX in the apache error_log. I might be way off, though,
> > so thanks for the correction.
> >
> You might be correct: if the OP now uses mod_plsql and Apache on
> a previously OAS based system.
> Back to the OP - Bob, shed your light...
>
> >> OAS (aka WebServer V4), which may very well be cause of the
> >> problem: the owa packages that came with 8i are not compatible
> >> with the OAS ones.
> >>
> >> Drop the 8i packages (believe they are owned by SYS), and recompile,
> >> or reinstall the OAS ones.
> >> If you have OAS... that is
> >
> >
> > Cheers,
> >
> > Holger
>
>
> --
>
> Regards,
> Frank van Bortel
>

Edit your $OH/Apache/modplsql/conf/wdbsvr.app and add ;error_style = GatewayDebug to the PLSQL_GATEWAY configuration.

This will tell you want went wrong.

[PLSQL_GATEWAY]
administrators = all
adminPath = /admin_/
;admindad =
;debugModules =
defaultDAD = simpledad

;upload_as_long_raw =
;upload_as_blob =
;enablesso =
;stateful =
;custom_auth =
;error_style = GatewayDebug