by the way, i am assuming that you are using sql*plus or something other than forms or procedure builder.