ORA-01001: invalid cursor when running dbms_tt.transprot_set

From: <jms.news_at_gmail.com>
Date: Fri, 08 Jun 2007 05:15:46 -0000
Message-ID: <1181279746.752771.32890@z28g2000prd.googlegroups.com>

Running dbms_tt.transport_set_check as sys generates an error:

SQL*Plus: Release 9.2.0.7.0 - Production on Fri Jun 8 15:13:00 2007

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production

SQL> connect sys_at_DEV as sysdba;
Enter password:
Connected.
SQL> execute dbms_tts.transport_set_check('USERS,INDEX', true ); BEGIN dbms_tts.transport_set_check('USERS,INDEX', true ); END;

*
ERROR at line 1:

ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_SYS_SQL", line 819
ORA-06512: at "SYS.DBMS_SQL", line 19
ORA-06512: at "SYS.DBMS_TTS", line 789
ORA-29304: tablespace 'INDEX' does not exist
ORA-06512: at "SYS.DBMS_TTS", line 818
ORA-06512: at line 1

Any ideas ? Received on Fri Jun 08 2007 - 00:15:46 CDT

ORA-01001: invalid cursor when running dbms_tt.transprot_set_check