stored procedure

Hello,
What is wrong with this stored procedure?

create procedure GB.sp_empty
as begin
spool D:\project\DBdata\y.sql
select 'drop ' || object_type || ' ' || owner || '.' || object_name || ';' from all_objects
where owner='GB'
and object_type in ('TABLE','VIEW')
spool off
@D:\project\DBdata\y.sql;
end;

How could I fix it?

Gennady Received on Thu Jun 10 1999 - 21:56:08 CDT