Bind Variable

Question

Summary Bind Variable Content Required to create a custom version of an Oracle Data definition to add a new field. The Data Definition dataQuery sqlStatement's are mostly populated via a beforeReport package trigger e.g. Can I reference one of the fields within Q_SUMMARY_SELECT as a following Bind Varaible ? I've tried but the value looks to be null. I don't want to waste time on the impossible :-) Thanks.

Vani-R · Answer

Not sure if this could be solution but, I think you can go for temporary table (which gets populated from pl/sql package )which can be used in another query

GaryWW · Answer

Not the solution that I was after, but some lateral thinking results in a different way round the issue. Happy days. Nice to know if there is a way around the null Bind Variable, though.

GaryWW · Answer

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 shows [STATEMENT] 1: COLUMN_NAME:null

Before spending time with the code I was querying whether Bind Variables work as normal when the referenced column is within an external package generated statement.

Hope this is clear ?