When trying to show the SQL for an external table the syntax shown is incomplete. (The special stuff for external tables is missing). What I'd also suspect is that the compare function would not work as expected either (but I did not verify this).
My PL/SQL Devoleper version is 7.02.1076