Select using partition dynamically

[Jose Lima]

Hi everybody,

I'm trying to put on my Store Procedure the following statement:

Select a, b, c, d
from <table name> partition (<partition name>)

The problem I'm facing is to put the <partition name> dynamically.
I can't use PREPARE STATEMENT.

Are ther any way to do it?
I tried it but do not work;

Select a, b, c, d
from <table name> partition (concat( 'p_', format_date( '%Y%m%d') ) )

Any help will be wellcome.

Regards,

José Lima