Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Mod Pl/SQL +Error trapping
Mod Pl/SQL +Error trapping [message #9937] Mon, 15 December 2003 23:45
Anthony Carter
Messages: 1
Registered: December 2003
Junior Member
Hi,

I have a problem that I can't seem to find the answer to anywhere.

I have developed an online questionnaire using mod pl/sql and Oracle 8.1.7. I use a DAD configured with a single login/password set (in the DAD) and doing my own authentication into my questionnaire.

However, the problem is if a user enters an invalid name of a procedure. I get the error (normal) that the procedure does not exist and then a whole host of juicy information about my environment, access ports etc. How do prevent this information on screen? I tried using a trigger as such:

CREATE or REPLACE TRIGGER procnotfound
AFTER servererror
ON DATABASE

BEGIN
webq.WEBQ_LOGIN_PAGE
END;

but i get the error:

ORA-04098: trigger 'WEBQ.PROCNOTFOUND' is invalid and failed re-validation
ORA-06550: line 7, column 2:
PLS-00201: identifier 'SOMETHING' must be declared
ORA-06550: line 7, column 2:
PL/SQL: Statement ignored

At a minimum I just want to prevent the listing of this:

DAD name: WEBQ
PROCEDURE : WEBQ.WEBQ_login_pags
URL : xxx.xxx.xxx.xxx
PARAMETERS :
============

ENVIRONMENT:
============
PLSQL_GATEWAY=WebDb
GATEWAY_IVERSION=2
SERVER_SOFTWARE=Apache/1.3.12 (Unix) ApacheJServ/1.1 mod_perl/1.22
GATEWAY_INTERFACE=CGI/1.1
SERVER_PORT=7777
SERVER_NAME=xxx.xxx.xxx
REQUEST_METHOD=GET
QUERY_STRING=
PATH_INFO=/pls/WEBQ/WEBQ.WEBQ_login_pags
SCRIPT_NAME=/pls
REMOTE_HOST=
REMOTE_ADDR=xxx.xxx.xxx.xxx
SERVER_PROTOCOL=HTTP/1.1
REQUEST_PROTOCOL=HTTP
REMOTE_USER=
HTTP_CONTENT_LENGTH=
HTTP_CONTENT_TYPE=
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
HTTP_HOST=xxx.xxx.xxx.xxx:7777
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-gb
HTTP_ACCEPT_CHARSET=
HTTP_COOKIE=WEBQ=1
Authorization=
HTTP_IF_MODIFIED_SINCE=

Thanks for any help.

Anthony
Previous Topic: Forms6i Form on Portal 9i
Next Topic: Passing parameter into a Java application called in an IFrame
Goto Forum:
  


Current Time: Fri Mar 29 04:30:35 CDT 2024