26 June 2011

Oracle 11g Express Edition bug?

Of course you know that Oracle has released 11g Express Edition, still in Beta though. That is probably why I ran into something weird -must be a bug- while playing with it. Here is what I did:

SQL> set echo on
SQL> col "Current_Edition" format a20
SQL> col object_name format a20
SQL>
SQL> select sys_context('userenv'
2 ,'current_edition_name'
3 ) "Current_Edition"
4 from dual
5 /

Current_Edition
--------------------
ORA$BASE

1 row selected.

SQL>
SQL> create or replace
2 procedure hello
3 is
4 begin
5 dbms_output.put_line ('Hello World');
6 end hello;
7 /

Procedure created.

SQL>
SQL> begin
2 hello;
3 end;
4 /
Hello World

PL/SQL procedure successfully completed.

SQL>
SQL> select object_name
2 , object_type
3 , edition_name
4 from user_objects_ae
5 where object_name = 'HELLO'
6 /

OBJECT_NAME OBJECT_TYPE EDITION_NAME
-------------------- ------------------- ------------------------------
HELLO PROCEDURE

1 row selected.

SQL>