Signature (parameter names) Mismatch error
- From: Dan Looby <dan.looby@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 03 Jun 2004 16:03:51 -0400
Our users are experiencing the following error when clicking on a class
search web page (generated by PL/SQL):
bwskfcls.P_CrseSearch: SIGNATURE (parameter names) MISMATCH
VARIABLES IN FORM NOT IN PROCEDURE:
NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM: TERM_IN
DAD name: b6tst
PROCEDURE : bwskfcls.P_CrseSearch
URL : http://bserv:1234/pls/b6tst/bwskfcls.P_CrseSearch
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=bserv
REQUEST_METHOD=GET
QUERY_STRING=
PATH_INFO=/pls/b6tst/bwskfcls.P_CrseSearch
SCRIPT_NAME=/pls
REMOTE_HOST=
REMOTE_ADDR=130.207.163.57
SERVER_PROTOCOL=HTTP/1.1
REQUEST_PROTOCOL=HTTP
REMOTE_USER=
HTTP_CONTENT_LENGTH=
HTTP_CONTENT_TYPE=
HTTP_USER_AGENT=Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
rv:1.6) Gecko/20040206 Firefox/0.8
HTTP_HOST=pool22.acms.gatech.edu:1234
HTTP_ACCEPT=text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,*/*;q=0.1
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_COOKIE=SESSID=TjRPQTZLMTI1NDA=; TESTID=set;
JServSessionIdroot=34ahp76h26
Authorization=
HTTP_IF_MODIFIED_SINCE=
Tech Support for the product says it is because in our httpd.conf file we
had 'KeepAlive' set to 'On' when it should be 'Off' and how SSL 3.0
handshakes (OK, that is beyond me). As suggested we changed such and
restarted all services...and still the error haunts our users.
Ideas?
Dan
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » Signature (parameter names) Mismatch error