Thanks, I wasn't aware that SQL plus would do that. That explains why the anonymous block works! - Ethan On 12/5/06, Alberto Dell'Era <alberto.dellera@xxxxxxxxx> wrote:
It is a SQL command (understood by the sql parser), but 9i sqlplus doesn't recognise it a a valid sql command (sqlplus parses the first word to determine whether it is a valid command - "purge" was not coded in 9i sqlplus). -- Alberto Dell'Era "Per aspera ad astra"