>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
>
>
>
>
>
>
>