Input truncated to 7499 characters

From: news <oscgonesp_at_hotmail.com>
Date: Fri, 13 Jun 2003 10:55:30 +0200
Message-ID: <bcc3ht$q7368_at_cesio.mundo-r.com>


Hi everyone

I have this problem with a script in Oracle 8.1.7. This script (script1) generates another script (script2) which contains command like: ...
/

drop table X
create table X
update Y set field1=".."
/

When script2 is running it show this error in a few commands:

DROP TABLE REP_O_TTF
/

CREATE TABLE REP_O_TTF AS SELECT * FROM O_TTF WHERE 1=2
/

UPDATE MSCATALOG SET REPORTTABLE = 'REP_O_TTF' WHERE TABLENAME = 'O_TTF'
/

commit
/

DROP TABLE REP_O_UTENTI
/

CREATE TABLE REP_O_UTENTI AS SELECT * FROM O_UTENTI WHERE 1=2
/

UPDATE MSCATALOG SET REPORTTABLE = 'REP_O_UTENTI' WHERE TABLENAME = 'O_UTENTI'
/

commit
/

Input truncated to 7499 characters
SP2-0027: Input is too long (> 2499 characters) - line ignored SP2-0027: Input is too long (> 2499 characters) - line ignored values
*
ERROR at line 10:
ORA-00947: not enough values

The script1 code is somethink like that:

set serveroutput on
set feed off
spool rep_table.tmp
BEGIN
dbms_output.enable(20000000);
for rec in
(
  select tablename
  from mscatalog
  where tablename like 'O_%'
)
loop
  dbms_output.put_line('DROP TABLE REP_'||rec.tablename);   dbms_output.put_line('/');

  dbms_output.put_line('CREATE TABLE REP_'||rec.tablename

                       || ' AS SELECT * FROM ' || rec.tablename || ' WHERE
1=2');
  dbms_output.put_line('/');
  dbms_output.put_line('UPDATE MSCATALOG SET REPORTTABLE = ''REP_' ||
          rec.tablename || ''' WHERE TABLENAME = ''' || rec.tablename ||
'''');
  dbms_output.put_line('/');
  dbms_output.put_line('commit');
  dbms_output.put_line('/');

end loop;
END;
/

spool off
set feed on
_at_rep_table.tmp

Could you help me?

Thanks anyway. Received on Fri Jun 13 2003 - 10:55:30 CEST

Original text of this message