Is the work around to use dynamic sql, and put the rank inside the statement?
Yes, prior to 9i the only option for using analytical functions in PL/SQL is to use dynamic sql (NDS or DBMS_SQL).
Jurij Modic ASCII a stupid question, get a stupid ANSI 24 hours in a day .... 24 beer in a case .... coincidence?
Forum Rules