----- Original Message -----
From: "DB? Solucoes" <db2listas@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, April 05, 2004 3:34 PM
Subject: Re: [firebird-support] Big Problem


> >That's not good. If you declare it BLOB, you have to provide
> > it with blob_id.
>
> And how i can do this?
>
>
> Thanks
>
>
> Gustavo Buchle
> Desenvolvimento
> DB² Solucoes
> (51) 99518712
>
>
>
> ----- Original Message -----
> From: "Dimitry Sibiryakov" <SD@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Monday, April 05, 2004 4:13 AM
> Subject: Re: [firebird-support] Big Problem
>
>
> > On 2 Apr 2004 at 21:24, DB Soluзхes wrote:
> >
> > > I have a problem with a database of one of my clients. It s the same
> > > database as all the other clients but when I call the following
> procedure,
> > >I
> > > get "Unsuccessful execution caused by a system error that precludes
> > > successful execution of subsequent statements. internal error." But
when
> I
> > > do the insert outside the procedure, it works just fine.
> >
> > Firebird automatically convert string values/constants for INSERT
> > statement, but doesn't do this for procedure parameters.
> >
> > > CREATE PROCEDURE GERENCIA_FAX(
> > > ACT INTEGER,
> > > ID_FAX INTEGER,
> > > ID_USUARIO INTEGER,
> > > ID_DOCUMENTO INTEGER,
> > > ID_SISTEMA_FAX INTEGER,
> > > NUMERO_ENVIO VARCHAR(20),
> > > PAGINAS_TOTAL INTEGER,
> > > PAGINAS BLOB SUB_TYPE 1 SEGMENT SIZE 10,
> >
> > I bet, you call this procedure, using a string as value for
> > PAGINAS. That's not good. If you declare it BLOB, you have to provide
> > it with blob_id.
> >
> > > STATUS SMALLINT)
> >
> > SY, Dimitry Sibiryakov.
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
>