Thanks Ian, that is probably a better solution. Right now though, it's too late, and I am too tired to follow it. :) I'll try again tomorrow. That, and my PL/SQL skills are still mostly Oracle 7. Jared On 6/14/05, MacGregor, Ian A. <ian@xxxxxxxxxxxxxxxxx> wrote: > > It is not readily apparent that this method is applicable to the problem, > and I deleted the original message. Variable where clauses can be handled > through sys_context. See > http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1288401763279 > > Ian MacGregor > Stanford Linear Accelerator Center > ian@xxxxxxxxxxxxxxxxx > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l