dbms_tts cannot work
I have a problem when running stored procedure on Oracle 11g after being upgraded from 10gr2:
SQL> begin
sys.dbms_tts.transport_set_check
('USERS', incl_constraints=>TRUE, full_check=>FALSE);
end;
/ 2 3 4 5
begin
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_TTS", line 790
ORA-06512: at "SYS.DBMS_TTS", line 888
ORA-06512: at line 2
It seems that dbms_tts is valid, but anyway I have recompiled it, but still getting the same error.
There is also a another smaller database instance on that server, using the same software where dbms_tts is working fine.
Any ideas?
Thanks