----- Original Message -----
Sent: Monday, August 08, 2005 6:59
PM
Subject: AW: [WO5.2.3] Problem with char
parameter in stored procedure(EOF mapping)
Hi Janine,
I was not quite sure, but I thought to remember something similar in
the far-away-back of my mind. I think that I'll force ;-) the database guy to
turn the changes back.
Thank you,
Stephan.
I belong to an Oracle discussion list (oracle-l) and just last week
someone mentioned that they had debugged a Java app that was having
performance issues and found the same thing - when a procedure parameter is
defined as CHAR, something (probably the Oracle driver but I don't think the
guy ever determined that for certain) was padding out the field to the full
possible length of a CHAR.
I wasn't paying that close attention but I think his solution was to
switch back to VARCHAR2. If that's possible in your case it might be the
easiest fix.
janine
On Aug 8, 2005, at 9:00 AM, Stresing, Stephan wrote:
Hi,
since I had a pause of over 1 year in WO
development I guess this is a rookie question
At least I hope so. (I'm
pretty sure I'll be ashamed after your answers.) :-)
Our database experts changed the interfaces of
some stored procedures we're forced to use. ;-) Mainly they modified some
string parameters and changed the type from VARCHAR2 to CHAR (length was/is
defined as 10 chars for either solution). I thought that I only had to
change my EOModel in order to reflect these changes. So I switched the
parameter type from VARCHAR2 to CHAR and didn't touch the width definition
(10).
Now after executing the "new" procedure with
EOUtilities.executeStoredProcedureNamed the result was surprising
(especially to me): the expected 10 chars String had a length of 32512. I
checked the "old" (VARCHAR2) procedure and got the expected 10 chars. What
am I missing? (Is this the revenge for not developing with WO for so long?
;-))
We're developing with WO 5.2.3 on Windows XP
(Eclipse/WOLips), Oracle Thin connecting to a remote Oracle
9i.
Since I'm stuck I'd appreciate fast
help!
TIA,
Stephan.
Stephan Stresing
IT Entwicklung &
Systemintegration
ING-DiBa AG
Postfach 18 49
90007 Nürnberg
Besucher:
Südwestpark 97
90449 Nürnberg
Fon +49 (0)9 11 - 1 49 - 2 25 37
Fax +49 (0)9 11 - 1 49 - 2 25 48
eMail mailto:email@hidden
WWW http://www.ing-diba.de
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain
confidential and/or privileged information. If you are not the intended
recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorized copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain
confidential and/or privileged information. If you are not the intended
recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorized copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
_______________________________________________
Do not post admin
requests to the list. They will be ignored.
Webobjects-dev mailing
list
(email@hidden)
Help/Unsubscribe/Update your
email sent to email@hidden