You Asked

Sir

I am getting the following error message after executing the command "SET DESCRIBE DEPTH 4 INDENT ON" at SQL prompt

SET DESCRIBE DEPTH 4 INDENT ON" is Obsolete

Please advise how to describe nested object types

Regards
DS Rao

and Chris said...

In SQL*Plus?

You're going to have to give us more details. It all looks fine to me:

SQL> create or replace type tp as object (
  2    a1 int
  3  );
  4  /

Type created.

SQL> create table t (
  2    c1 tp
  3  );

Table created.

SQL>
SQL> SET DESCRIBE DEPTH 4 INDENT ON
SQL>
SQL> desc t
 Name              Null?    Type
 ----------------- -------- ------------
 C1                         TP
   A1                       NUMBER(38)

And there's nothing in the docs to say it's obsolete: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqpug/SET-system-variable-summary.html#GUID-2BB91A27-4681-4AD2-890D-BBE78C954D77

Is this answer out of date? If it is, please let us know via a Comment