--- In firebird-support@yahoogroups.com, "karolbieniaszewski" <liviuslivius@...> wrote:

>
>
> --- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@> wrote:
> >
> > > > karolbieniaszewski wrote:
> > > > > how can i check what dependicies exists on field listed in
> > > > > RDB$FIELDS?
> > > > >
> > > > > SELECT *
> > > > > FROM RDB$FIELDS a
> > > > > WHERE
> > > > > a.RDB$FIELD_NAME like 'RDB$1749%'
> > > > >
> > > > > result me 1 record
> > > > > but
> > > > >
> > > > > SELECT *
> > > > > FROM RDB$RELATION_FIELDS a
> > > > > where
> > > > > a.RDB$FIELD_SOURCE like 'RDB$1749%'
> > > > >
> > > > > return 0 records
> > > >
> > > > Maybe it's a stored procedure parameter?
> > > >
> > > > --
> > > > Milan Babuskov
> > >
> > > I check this and this is output parameter for my stored procedure
> > > but this procedure is not used in any object in database - only is
> > > executed by client application
> > >
> > >then how can i have dependencies on this parameter??
> >
> > Did you drop or alter the stored procedure? I would expect the stored procedure to depend on the domain of its output parameter to be defined.
> >
> > HTH,
> > Set
> >
>
> Yes i drop stored procedure and few parameters are defined like
> name my_domain instead of e.g. name VarChar(10)
> but procedure have no dependicies and domain still exists and was not modified..
>
> And most interesting is that
> start transaction
> drop procedure
> commit transaction - generate error
>
> but when i run the same once again
> start transaction
> drop procedure
> commit transaction
>
> i successfully drop procedure without error ..
> I suppose that is some issue in dependicies of domain type paremer..
>
> Karol Bieniaszewski
>

one correction to above
i have not parameters on domain only variables inside proc declared as
domain
eg. DECLARE VARIABLE E_SMS_SYSTEM DOMAIN_SYSTEM;
parameters are simple integer type
and error about dependicies is for my input parameter
"INC_ILE_OBROBIONO_BY"

procedure header look like
CREATE PROCEDURE OBRABIAJ_BUF (
INC_ILE_OBROBIONO_BY Integer )
RETURNS (
ILE_OBROBIONO Integer )
AS

Karol Bieniaszewski