dbms.tts

Hi
I am getting this error when I am trying to run this---

SQL> EXECUTE SYS.DBMS.TTS_TRANSPORT_SET_CHECK('TS_01',TRUE);
BEGIN SYS.DBMS.TTS_TRANSPORT_SET_CHECK('TS_01',TRUE); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored.

It was used to run successfully before.

Any help would be appreciated.

thanks in advance.

Smruti1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
johnsoneConnect With a Mentor Senior Oracle DBACommented:
It should be:

sys.dbms_tts.transport_set_check('TS_01', TRUE);

You have some of the "."s and "_"s mixed up.
0
 
Smruti1Author Commented:
Thanks johnsone.

You are right . It was my mistake.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.