[WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
[WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
- Subject: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
- From: "Stresing, Stephan" <email@hidden>
- Date: Mon, 8 Aug 2005 18:00:21 +0200
- Thread-topic: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
Title: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
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