AW: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
AW: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
- Subject: AW: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
- From: "Stresing, Stephan" <email@hidden>
- Date: Mon, 8 Aug 2005 19:08:33 +0200
- Thread-topic: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
Just me again:
I think the "varchar" switch-back is only necessary for OUT or IN OUT
parameters, isn't it? If I'm feeding an IN parameter the CHAR
issue shouldn't matter. Please correct me if I'm wrong.
Thanks,
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:
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.