Oracle Reports (MOSC)

MOSC Banner

Execution Order of Computed columns in report

edited Mar 3, 2010 8:41PM in Oracle Reports (MOSC) 4 commentsAnswered
Hi,

I am developing a report which queries several columns.  In the resulting group I also created several computed columns.  Some of the computed columns are based on the results of other computed columns in the same group.  As long as the PL/SQL for all of the dependent computed columns is ran after the computed columns they're dependent on, then the report should run fine.  My question is, will they?  How do I know the sequence the computed columns' PL/SQL will execute in?

From a preliminary test I can't tell what determines the order.  I put in code to output to the log the name of the computed field that is being run so I could see the order things were happening in.  I ran it several times and the order is consistent, however the order isn't alphabetic nor does it match the sequence of the columns in the group.

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