> > so some possible design can be: > > DECLARE > PRAGMA UNCACHED_PLANS; > BEGIN > SELECT ... INTO ; > SELECT ... INTO ; > END; > > This respects Ada and PL/SQL style - probably easy implementation > > Regards > > Pavel >
some examples based on Ada doc FUNCTION xxx RETURN int AS PRAGMA yyy -- pragma has function scope BEGIN FUNCTION xxx RETURN int AS BEGIN DECLARE PRAGMA yyy -- pragma has block scope Regards Pavel > > >> >> Regards >> >> >> >> >> >>> >>> merlin >>> >> >> >