DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION Results in ORA-06550 and PLS-00201 (Doc ID 159968.1)

Last updated on AUGUST 30, 2017

Applies to:

PL/SQL - Version 7.3.4.5 and later
Information in this document applies to any platform.

*** Checked for relevance on 30-Aug-2017 ***

Symptoms

Executing PL/SQL code containing call to DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION is failing during runtime with following errors:

ORA-06550: line %s, column %s:\n%s
PLS-00201: identifier %s must be declared
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must
be declared

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms