Subject | Re: Too many Contexts ... Maximum allowed is 127. |
---|---|
Author | m_brahim11 |
Post date | 2011-01-27T17:16:44Z |
Thanks for the answer.
But why these restrictions : 127 in FB 1 and 255 in FB 2 ?
But why these restrictions : 127 in FB 1 and 255 in FB 2 ?
--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:
>
> On 1/27/2011 9:23 AM, m_brahim11 wrote:
> >
> > Is it possible to know by SQL in FB 2.5 what is the number of contexts
> > used by a specific SP in order to prevent the
> > Too many Contexts of Relation/Procedure/Views message ?
> > I mean, the totally dependencies for a specfic SP.
> >
>
> Not by SQL. The restriction applies to a single query, not the
> whole stored procedure, so you'll need to look at each query
> individually and each view in each query and each view in each
> view...
>
> Good luck,
>
> Ann
>