This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,583 Users
  • 2,269,776 Discussions
  • 7,916,824 Comments

Discussions

Information command in SQLcl gives ORA-20005 error

Wouter Breeuwsma
Wouter Breeuwsma Member Posts: 25 Blue Ribbon
edited May 3, 2016 1:54PM in SQLcl

Hi all,

I am investigating the new SQLcl tool with all the great features (version sqlcl-4.2.0.16.049.0843).

When I try to get information from the employees table in the HR schema I get some errors. I have entered:

info hr.employees;

and get:

ORA-20005: ORU-10034: context argument must be 1 or 2 or 3 or 4 or 5 or 6 or 7

ORA-06512: in "SYS.DBMS_UTILITY", regel 112

ORA-06512: in regel 1

This occurs on a 10g R2 EE database on a Virtual Box machine. I get the same error with SQL Developer 4.1.3.20.

What can be the reason for this?

On a 11XE database it is working with SQL Developer 4.1.3.20.

Regards, Wouter

Best Answer

  • Dear DBA Frank
    Dear DBA Frank FranceMember Posts: 177 Bronze Badge
    edited Apr 21, 2016 11:20AM Answer ✓

    Hello

    I confirm that both the info and info+ commands are not compatible with version 10g of the database.  Ever since these new commands came out, I have tested them on 11g, 12c, and 10g, and while they work fine in 11g and 12c, they always give that ORU-10034 error in 10g.  Note that both can be run in SQLDeveloper proper, on top of SQLCL.

Answers