Signature (parameter names) Mismatch error

From: Dan Looby <dan.looby_at_oit.gatech.edu>
Date: Thu, 03 Jun 2004 16:03:51 -0400
Message-Id: <6.0.0.22.2.20040603155524.030f9438@pop.mail.gatech.edu>

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 03 2004 - 15:03:32 CDT