dyn sql in stored procedure

Database
BPP
N/A

dyn sql in stored procedure


SET dyn_sql =
'Select TableName into hTableName from ' || TRIM(i_FullWorkTableName) ||
';'
;
call dbc. SysExecSQL(:dyn_sql)
;

SET dyn_sql =
'call sysdba.spETL_Table_' || hTableName|| '(:i_FullStageTableName);'
;
call dbc. SysExecSQL(:dyn_sql)
;

I get this when above is called. compiles correctly.

5568 SQL statement is not supported within a stored procedure.

What I am trying to do is call a stored procedure to work on specific table. I can get table name as an input parameter or sel from a table.
call spetl_a
call spetl_b
call spetl_c

any ideas will be appreciated.

Thanks in advance!
Bhanu P