Yes, but the length of the parameters does not increase while the insertion
of data with this procedure. It increase if I change somthing in the SP. For
example: I add a parameter TESTId INTEGER and then I commit my changes to
the SP. After or while the commit the length of the other VARCHAR parameter
changes!!

-----Ursprüngliche Nachricht-----
Von: German Terrazas [mailto:german@...]
Gesendet: Freitag, 7. März 2003 13:27
An: Ib-Support (E-Mail)
Betreff: Re: [ib-support] Strange things happen to SP Parameter



you should use trim function before insertion.

On Fri, 7 Mar 2003, Andreas Schmidt wrote:

> Hi all,
> I use the latest stable Firebird release with Delphi 5 Pro. and the
FIBPlus
> Components. In my Database there are several Stored Procedures. Some of
them
> have about 20 Parameter of different types like INTEGER or VARCHAR. Most
of
> the VARCHAR-Parameter have a length of about 100 to 255 charachters and I
> use UNICODE_FSS characterset.
>
> Now to my problem:
> After I´ve changed a SP or did something else in the DB with
> Firebird-Workbench or EMS Firebird Manager the length of my VARCHAR and
CHAR
> Parameters is changing itself!!! E.g NAME VARCHAR(200) gets to NAME
> VARCHAR(765) after I commit the changes to the SP. This stops only when
> Firebird says: '...implementation limit exceded...' and my Parameter have
a
> length of about 3000 charachters!!!!!.
>
> What´s going on? Is this a bug or a wrong DB Design on my side? Are the SP
> Parameter limited?
>
> Please help me!!!!!!
> (Sorry for my maybe bad english!!!:-))
>
> Andy
>
>
>
>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/