Comments on Surachart Opun's Blog: Objects Invalid when Enable Row Movement

@Coskan Gundogar Thank You for your comment

2010-05-04T10:21:35.409+07:00

@Coskan Gundogar

Thank You for your comment

Looks like things are changed on 11GR2 HR@ORACOS...

2010-05-04T08:12:53.379+07:00

Looks like things are changed on 11GR2

HR@ORACOS> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 -

Looks like things are change in 11GR2 HR@ORACOS&...

2010-05-04T08:11:30.433+07:00

Looks like things are change in 11GR2

HR@ORACOS>
CREATE OR REPLACE PROCEDURE p_test_table (
test_sql out varchar2) is
BEGIN
select substr(sqltext,5) into test_sql from test_table where rownum=1;
dbms_output.put_line(test_sql);
END p_test_table;
2 3 4 5 6 7 /

Procedure created.

HR@ORACOS> create

thanks for share.

2010-04-09T15:04:04.146+07:00

thanks for share.