I am logged in as scott/tiger and performing

SQL> select dbms_metadata.get_ddl('TABLE','EMP') from dual;
ERROR:
ORA-06502: PL/SQL: numeric or value error
ORA-00942: table or view does not exist


when I do a select * from emp and can see the table.

Any ideas?