Dynamic Sql in stored Procedure

Database

Dynamic Sql in stored Procedure

Hello ALL,

Is it possible to give host variables in slection list in dynamic sql in stored procedure.

For ex: select :Col1 , :Col2  from :database.tablename  where source_system = : col3'

for our process have to fetch from different cols from same table  based on source_system  and from different databases , table names are same.