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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 19 Feb 2004 13:26:28 -0000
Message-ID: <4034b984$0$7068$ed9e5944@reading.news.pipex.net>

8.1.7.4.1

SQL> create sequence my_seq;

Sequence created.

SQL> ed
Wrote file afiedt.buf

  1 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

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message
news:73e20c6c.0402190308.16e9171e_at_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 - 07:26:28 CST