SQL & PL/SQL

Hi,
I need to create a script that will generate the script for creating views in a particular view. I did the following

SQL> set heading off;
SQL> spool c:\create_view.sql
SQL> select 'CREATE OR REPLACE VIEW '|| VIEW_NAME || ' AS '||TEXT FROM ALL_VIEWS
 WHERE OWNER='SCOTT';
select 'CREATE OR REPLACE VIEW '|| VIEW_NAME || ' AS '||TEXT FROM ALL_VIEWS WHERE OWNER='SCOTT'
                                                        *
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got LONG

Is there any other way to get this done.

Thanks
Muneer