Can someone with access to 8ir3 test this for me please?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 19 Feb 2004 03:08:02 -0800
Message-ID: <73e20c6c.0402190308.16e9171e@posting.google.com>

Here is what clunks in 9ir2, reduced form:

SQL> select * from user_sequences;
Press Return to continue...

SEQUENCE_NAME                   MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE

LAST_NUMBER

------------------------------ ---------- ---------- ------------ - - ----------
 -----------
MY_SEQ                                  1 1.0000E+27            1 N N         20
           1

Elapsed: 00:00:00.05

SQL> set echo on
SQL> start zot
SQL> declare

  2 my_int pls_integer;
  3 my_str varchar2(2000);
  4 begin
  5 my_str:= 'alter sequence my_seq minvalue :moah';   6 my_int:= 10;
  7 execute immediate my_str using my_int;   8 end;
  9 /
declare
*
ERROR at line 1:
ORA-01722: invalid number
ORA-06512: at line 7

Elapsed: 00:00:00.00
SQL> I need to know if this also happened in 8ir3? Many TIA for any help.
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Thu Feb 19 2004 - 05:08:02 CST