Looks like it doesn't like ANSI join syntax, otherwise it works fine. Stay away from ANSI join syntax ;-) On Wed, Sep 19, 2012 at 3:17 PM, Stephens, Chris <Chris.Stephens@xxxxxxx> wrote: > Any idea why the procedure fails when joining 2 tables? > -- Alex Fatkulin, http://afatkulin.blogspot.com Enkitec, http://www.enkitec.com -- //www.freelists.org/webpage/oracle-l