Marco,

I have not inserting or updating records with blobs inside triggers or
stored procedures. The records are inserted through a Java application.

Thanks,

Rafael Santini

----- Original Message -----
From: "mk_delphi" <mk_delphi@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, February 17, 2004 7:36 PM
Subject: [firebird-support] Re: BLOB not found


> Hi Santini,
>
> Someone reported a bug (related to IB6) giving
> "BLOB not found" error in this scenario:
> inserting or updating records with blobs inside
> triggers and storerd procedure (mainly copiing
> them from the same table), i.e. for example in
> an after update trigger insert another record
> in the same table using the "new.blobname" as
> value. To avoid this get UDF library which has
> functions to convert from blob to string (e.g.
> f_blobAsPchar), and from string to blob (e.g. f_strBlob).
> Then you can insert blob fields from procedures and
> triggers. For example,
> insert into tableWithBlob(blobField)
> values(f_strBlob(f_blobAsPchar(new.blobField)));
>
>
> Ciao!
> Marco Kregar
> www.firebirdsql.it
>
> --- In firebird-support@yahoogroups.com, "Santini"
> <santini.lista@t...> wrote:
> > Hi,
> >
> > What means the following error ?
> >
> > gbak: error accessing BLOB column VAL -- continuing
> > gbak: ERROR: BLOB not found
> > gbak: 200000 records written
> > gbak: 220000 records written
> > gbak: ERROR: segment buffer length shorter than expected
> > gbak: ERROR: gds_$get_segment failed
> > gbak: Exiting before completion due to errors
> >
> > I ran gfix -v -full database.gdb but nothing is returned, this is,
> the
> > database isnt corrupted.
> >
> > Any idea ?
> >
> > Thanks,
> >
> > Rafael Santini
>
>
>
> --------------------------------------------------------------------------
------
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
> --------------------------------------------------------------------------
------
> Esta mensagem foi verificada pelo E-mail Protegido Terra.
> Scan engine: VirusScan / Atualizado em 17/02/2004 / Versão: 1.4.1
> Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/
>
>
> --------------------------------------------------------------------------
------
> E-mail classificado pelo Identificador de Spam Inteligente.
> Para alterar a categoria classificada, visite
http://www.terra.com.br/centralunificada/emailprotegido/imail/imail.cgi?+_u=santini.lista&_l=1077057378.365872.25143.estero.terra.com.br