The select is part of an insert statement and the error is
thrown because you cannot use longs or long raws in an insert..select
statement. This is true in all versions. However an error is not thrown at compile time until 9i. In 8i it only fails at runtime.
You do not need a parachute to skydive. You only need a parachute to skydive twice.