Not wroking like SqlPlus : "alter session set current_schema"

[RobertK]

10gR2
6.0.6.947

In Command Window:

SQL> desc emp
Object emp does not exist.

SQL>  alter session set current_schema = scott;

Session altered

SQL> desc emp
Object emp does not exist.

SQL> select count(*) from emp;

  COUNT(*)
----------
        14

Unlike Sqlplus, "describe" does not work after set_schema ...is this a know issue ?
Any fix ?
thanks

 

[Marco Kalter]

There is indeed no explicit support to set the current_schema. I have added this to the list of enhancement requests.