Partitions are not excluded in stored procedures

Hi there,

I came across the following problem. Say I have a select query that
given the appropriate where clauses it will only query the correct
partitioned tables and not all of them.  That can be examined by using
the EXPLAIN. However the same select query used in a stored procedure
will transverse all the tables regardless of the where clause parameters
passed by the user as variables of the stored procedure . Is there any
work around other than composing an EXECUTE "select ....."?

Kind Regards
Yiannis