Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1041
  • Last Modified:

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.

0
Smruti1
Asked:
Smruti1
1 Solution
 
johnsoneSenior 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now