Originally posted by rajabalachandra
hi,

how do i take current scn from oracle 8i?

-Raja
Hi! Try this:

Code:
SQL> create global temporary table t ( x number );

Table created.

SQL> create or replace function get_scn return number
  2  as
  3      pragma autonomous_transaction;
  4      l_scn number;
  5  begin
  6      insert into t values ( userenv('commitscn') ) returning x into l_scn;
  7      commit;
  8      return l_scn;
  9  end;
 10  /

Function created.

SQL> select get_scn from dual;

   GET_SCN
----------
   2086229

SQL>