Return-Path: 
 <users-return-4623-apmail-httpd-users-archive=httpd.apache.org@httpd.apache.org>
Delivered-To: apmail-httpd-users-archive@httpd.apache.org
Received: (qmail 38905 invoked by uid 500); 2 Apr 2002 01:23:09 -0000
Mailing-List: contact users-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@httpd.apache.org
list-help: <mailto:users-help@httpd.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@httpd.apache.org>
list-post: <mailto:users@httpd.apache.org>
Delivered-To: mailing list users@httpd.apache.org
Received: (qmail 38892 invoked from network); 2 Apr 2002 01:23:08 -0000
Received: from ext-nj2gw-3.online-age.net (216.35.73.165)
  by daedalus.apache.org with SMTP; 2 Apr 2002 01:23:08 -0000
Received: from int-nj2gw-1.online-age.net (int-nj2gw-1.online-age.net
 [3.159.236.65])
	by ext-nj2gw-3.online-age.net (8.9.3+Sun/8.9.1/990426-RLH) with ESMTP id
 UAA14083
	for <users@httpd.apache.org>; Mon, 1 Apr 2002 20:23:16 -0500 (EST)
Received: from xcin01corpge.ge.com (localhost [127.0.0.1])
	by int-nj2gw-1.online-age.net (8.9.3+Sun/8.9.1/990426-RLH) with ESMTP id
 UAA10401
	for <users@httpd.apache.org>; Mon, 1 Apr 2002 20:23:15 -0500 (EST)
Received: by xcin01corpge.ge.com with Internet Mail Service (5.5.2653.19)
	id <HCX8PJ2F>; Mon, 1 Apr 2002 20:23:14 -0500
Message-ID: <2C6C2E237F25D511991F00D0B73E91A60A48BB6A@xfld05corpge.ge.com>
From: "Vangeepuram, Chary (CORP, Consultant)"
	 <Chary.Vangeepuram@corporate.ge.com>
To: users@httpd.apache.org
Subject: mod_plsql error
Date: Mon, 1 Apr 2002 20:21:25 -0500 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi,
This is a problem in mod_plsql area. In pl/sql package, all stirng variables
have enough space to accommodate user queries. Can someone help me if you
have resolved such scenario ? The line numbers referred in the error log
leave no clue..

Thanks - Chary.


>>>>>>>>>>>>>>>>>>>
Win Nt 4.0 SP 6a

Apache 1.3
mod_plsql v3.0.9.8.3b PlugIn for Oracle HTTP Listener 
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production With the
Partitioning option JServer Release 8.1.7.2.0 - 64bit Production
Error Log:
>>>>>>>>>>>>
[Mon Apr 01 09:01:04 2002] [warn] mod_plsql: Stale Connection due to Oracle
error 6502
[Mon Apr 01 09:01:04 2002] [error] mod_plsql:
/pls/cosapp/pkg_cos_p_search.p_pos_f_srch_crt ORA-6502
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "COSAPP01.OWA", line 13
ORA-06512: at line 4
------
[Mon Apr 01 09:01:24 2002] [warn] mod_plsql: Stale Connection due to Oracle
error 6502
[Mon Apr 01 09:01:24 2002] [error] mod_plsql:
/pls/cosapp/pkg_cos_p_search.p_pos_f_srch_crt ORA-6502
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "COSAPP01.OWA", line 13
ORA-06512: at line 4
>>>>>>>>>>>>>>





---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org