Hi, Vlad

as you have instructed:

> > in_sqlda->sqlvar[0].sqldata = (char *) &blob_id;
> > in_sqlda->sqlvar[0].sqltype = SQL_BLOB+1;
>
> (1) here you say: the field\parameter is nullable
>
> > in_sqlda->sqlvar[0].sqllen = strlen(blob_buffer);
>
> (2) here you must put sizeof(blob_id)
>
> > in_sqlda->sqlvar[0].sqlind = NULL;
>
> and here you must supply NULL-indicator because of (1)

Now it is:

int nullid = 0; // short nullid = -1; nullid = 1;
// int *nullid = 0;
in_sqlda->sqlvar[0].sqldata = (char*) &blob_id;
in_sqlda->sqlvar[0].sqltype = SQL_BLOB+1;
in_sqlda->sqlvar[0].sqllen = sizeof (blob_id);
in_sqlda->sqlvar[0].sqlind = &nullid;

There is now NO more error message, for the function hangs inside the isc_dsql_execute_immediate(..) call, and NEVER gets out...

any further suggestions?

yours
o'rock