Comment on column problem

From: <protasov_at_my-dejanews.com>
Date: Tue, 23 Jun 1998 14:23:33 GMT
Message-ID: <6modp4$ecc$1@nnrp1.dejanews.com>

Hi All,

Yesterday I found something very interesting in Oracle 8.0.3 for NT. Here is the script:

SVRMGR> drop view v;
Statement processed.
SVRMGR> drop function f;
Statement processed.
SVRMGR> create force view v as select f a from dual; Statement processed.
SVRMGR> create function f return varchar2 is begin return null; end;

     2> /
Statement processed.
SVRMGR> alter view v compile;
Statement processed.

SVRMGR> select column_name,data_type from user_tab_columns
     2> where table_name='V'
     3> order by column_id;
COLUMN_NAME                    DATA_TYPE


------------------------------ ------------------------------


A                              VARCHAR2

1 row selected.
SVRMGR> comment on column v.a is 'Column A'; Statement processed.

It works fine. Now comment out alter view statement and rerun script:

SVRMGR> drop view v;
Statement processed.
SVRMGR> drop function f;
Statement processed.
SVRMGR> create force view v as select f a from dual; Statement processed.
SVRMGR> create function f return varchar2 is begin return null; end;

     2> /
Statement processed.

SVRMGR> --alter view v compile;
SVRMGR> select column_name,data_type from user_tab_columns
     2> where table_name='V'
     3> order by column_id;
COLUMN_NAME                    DATA_TYPE


------------------------------ ------------------------------


A                              UNDEFINED

1 row selected.
SVRMGR> comment on column v.a is 'Column A';

No respond. Oracle80 process eats almost 100% of processor time and used memory is constantly growing. This ends with system message 'Out of virtual memory' after some minutes. Page file is 100m. I must shutdown and reboot system.

It seems the problem is with comment on column of undefined type. The same script works fine with Oracle 7.2.2 under OS/2. So one should compile view before commenting its columns.

Can anyone confirm the described behavior of Oracle 8.0.3 on other OS other than NT4? Was the problem fixed in 8.0.4 and higher versions?

Andrew Protasov

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 23 1998 - 09:23:33 CDT