Recent content by stevem

Ah yes, that is true - a table. This is a legacy app ported to oracle, so oracle inherited it. We have been talking more recently about changing the table name because it is causing some issues with materialized views as well. Didn't cross my mind for this issue. Thanks for enlightening me on...

SQL> exec sys.dbms_output.put_line('TEST') BEGIN sys.dbms_output.put_line('TEST'); END; * ERROR at line 1: ORA-06550: line 1, column 11: PLS-00302: component 'DBMS_OUTPUT' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

SQL> set serveroutput on size 1000000 SQL> exec dbms_output.put_line ('TEST') TEST PL/SQL procedure successfully completed. SQL> Now in PL/SQL developer (v 5.1.6.747) with same user running (as an example) "select count(*) from dual", I get an error box with: ORA-06550: line 3, column 9...