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