GaryWW — Oracle Analytics

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

GaryWW Rank 3 - Community Apprentice

Comments

  • Not the solution that I was after, but some lateral thinking results in a different way round the issue. <sqlStatement name="Q_SUMMARY_SELECT"> <![CDATA[ SELECT T.COLUMN_NAME, J.* FROM TABLE_NAME T INNER JOIN ( &P_SUMMARY_SQL_STATEMENT AND :L_RUN_SUMMARY_REPORT = 'Y' ) J ON J.COLUMN_NAME = T.COLUMN_NAME ]]> </sqlStatement>…
  • Apologies for any confusion. The existing Data Definition includes sqlStatement Q_SUMMARY_SELECT which is populated via a PL/SQL package into &P_SUMMARY_SQL_STATEMENT. I'm wanting to reference on of the output fields from that statement in a following sqlStatement definition. I've tried using :COLUMN_NAME but request log…