Oracle Reports (MOSC)

MOSC Banner

Dynamic Columns Selection

edited Nov 26, 2013 12:22AM in Oracle Reports (MOSC) 8 commentsAnswered ✓
 Hi All
I need to select columns dynamically in select statement. For example on the basis of few parameters select clause will select col1,col2,col3 and on other parameter values  select clause will select col3,col2,col1. I am trying to achieve this through bind parameters like SELECT :p_col1 and in AFTERPARAMETERFORM trigger I am returning column names. But in output instead of data returned string is being selected. How to resolve this?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center